"Sinisa Stokic" <SinisaStokic@discussions.microsoft.com> wrote in message
news:A9288655-0E02-4E3B-805A-8B12238E1036@microsoft.com...
> 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