dbTalk Databases Forums  

Running Execute DTS 2000 Package Task on Win 64

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Running Execute DTS 2000 Package Task on Win 64 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
RQGal
 
Posts: n/a

Default 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!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.