Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS Package, Scheduling , Error

Author  Topic 

dupati1
Posting Yak Master

123 Posts

Posted - 2005-06-14 : 08:30:18
Guys,
What does this error mean? How do i correct it. When i run the package manually it works fine without any problems...when i schedule it, i get this error..

Executed as user: SQL_REPORTS\SYSTEM. ...ing...   
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1,
Error = -2147221005 (800401F3)
Error string: Invalid class string
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
Error Detail Records:
Error: -2147221005 (800401F3); Provider Error: 0 (0)
Error string: Invalid class string
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
Error: -2147221005 (800401F3);
Provider Error: 0 (0)
Error string: Invalid class string
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4700
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package exec. The step failed.


Thanks in advance
   

- Advertisement -