-
Problem DTSRUN
Hi,
we are actually runnning some test on a new server and i have a problem running my DTS with the DTSRUN utility
When i run my DTS manually from the Local package list, it work fine
Now, i have create a new DTS containing only my SQL task and 1 connection.
When running this DTS, i am receiving a mail from the called DTS. so i guess that the DTS is loaded succesfully.
When i run the DTS command in Query analyzer, i am getting this message
EXEC master..xp_cmdshell "dtsrun /sServerName/uUserName /nTransfer PRODUCTS from Apollo to CMS"
DTSRun: Loading...
DTSRun: Executing...
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: sqldts.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: sqldts.hlp
Help context: 1100
Any help appreciated
Martin
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|