BUG: DTSRUN Fails to Run Package Stored in Repository on Secondary Node of Cluster (274762)



The information in this article applies to:

  • Microsoft SQL Server 7.0

This article was previously published under Q274762
BUG #: 58432 (SQLBUG_70)

SYMPTOMS

When a DTS package is saved to the repository on a cluster, and the package is then run using DTSRUN.exe from the secondary node of the cluster, execution may fail with the following error message:
Error: -2147220404 (8004044C);
Provider Error: 0 (0)
Error string: The Microsoft Repository COM Server has not been
registered on this system.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 705

WORKAROUND

Save the package to SQL Server, not the SQL Server Repository.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.

Modification Type:MajorLast Reviewed:9/4/2002
Keywords:kbbug KB274762