I am trying to run the following statements from a stored procedure in SQL
SERVER 2008 64 bit version.




SELECT @cmd1 = 'DTSRUN /S ' + @serv + ' /U xxxxx /P xxxxxx /N
Process_DTS_Package'





EXEC XP_CMDSHELL @cmd1

I think there is only limited DTS functionality on 64 bit operating systems.
I am getting the below error while running the procedure

DTSRun: Loading...

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: 713
NULL

I just want to know whether I need to install any 32 bit DTS utilities to
run the above DTSRUN Commands on the 64 bit environment.

Looking for your valuable help on this.

Thanks....

ePD2010 wrote:
have a look here:
http://msdn.microsoft.com/en-us/library/bb500440.aspx
Support for Data Transformation Services (DTS) in SQL Server 2008

there you should find everything you need

hth,
Gerald