I've created a DTS that gets data from a foxpro source into a SQLServer
destination.
The DTS runs perfectly fine through the Enterprise manager, and infact works
fine on the command line, but when I try to initiate it through a Stored Proc
(I use :
EXEC @result = master.dbo.xp_cmdshell 'dtsrun /S <db> /U <admin> /P <pwd>
/N <DTS>') and I get this list of errors
-------------------------------------------
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_2
DTSRun OnStart: DTSStep_DTSDataPumpTask_3
DTSRun OnError: DTSStep_DTSDataPumpTask_2, 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_2
DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147221005 (800401F3)
Error string: Invalid class string
-------------------------
I though that it was a permissions issue, but I moved the data source to the
same machine as the SQLServer instance, and I still get this error.

Can anybody shed some light on this issue?

Thanks
Sinisa

Where is the stored proc? On the local box also?

What does DTSStep_DTSDataPumpTask_2 do?

What version of SQL Server with Service Pack.

The following articles explain the times I have most often see this erro
rmessage

http://support.microsoft.com/?kbid=288910


Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)







"Sinisa Stokic" <SinisaStokic (AT) discussions (DOT) microsoft.com> wrote