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