DTS run from SQL SERVER 2008 64 BIT

DTS run from SQL SERVER 2008 64 BIT

Post by ZVBEMjAxM » Thu, 10 Sep 2009 21:50:17


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....
 
 
 

DTS run from SQL SERVER 2008 64 BIT

Post by Gerald Aic » Fri, 11 Sep 2009 02:41:28


[...]

have a look here:
http://www.yqcomputer.com/
Support for Data Transformation Services (DTS) in SQL Server 2008

there you should find everything you need

hth,
Gerald