Running Execute DTS 2000 Package Task on Win 64 -
04-26-2006
, 02:15 PM
I have imported a series of SQL 2000 DTS packages to our 64bit AMD SQL
2005 server. I then created SSIS pkgs to run each SQL 2000 package
using teh Execute DTS 2000 package task. Then I deployed these packages
to the Yukon server as well.
I can run these packages when launching them via Integration Services
from Management Studio on my workstation, but when I try to run them
via a SQL Job or the DTExec command on the server, I get this error.
Anyone know of a workaround?
OnError,xxxxxx,xxxxxxx,Execute DTS 2000 Package
Task,{94769783-575C-4D1E-90F6-C2BDB3EA3CE2},{E05551C1-CDDE-40E3-87B4-C65D4E1B3A53},4/26/2006
3:01:37 PM,4/26/2006 3:01:37 PM,0,0x,This task does not support native
Win64 environment. Please run the package in 32-bit WOW environment
instead.
OnError,xxxxxx,xxxxxxx,Execute DTS 2000 Package
Task,{94769783-575C-4D1E-90F6-C2BDB3EA3CE2},{E05551C1-CDDE-40E3-87B4-C65D4E1B3A53},4/26/2006
3:01:37 PM,4/26/2006 3:01:37 PM,-1073594105,0x,There were errors during
task validation.
Is the DTS 2000 Package Task not supported on Win64?
I have installed the SQL Server 2000 DTS components from the November
feature pack on both my workstation and the server.
Thanks for your help! |