SQL 2000 DTS 32bit packages on SQL 2005 64bit

Question

SQL 2000 DTS 32bit packages on SQL 2005 64bit

davidsalazar01

SSCarpal Tunnel

Points: 4072
More actions
November 8, 2007 at 9:21 am

#118805

Does anybody know if you can execute a SQL 2000 32bit package on a SQL 2005 64bit server? I've imported the packages to the SQL 2005 64bit server and I can see them all under legacy.
But I've read something at this URL http://technet.microsoft.com/en-us/library/ms137907.aspx that is confusing to me.
It states "You cannot use the Execute DTS 2000 Package task in a package that is running in 64-bit mode on a 64-bit computer. There is no 64-bit design-time or run-time support for Data Transformation Services (DTS) packages that were created in earlier versions of SQL Server. For more information, see SQL Server 2005 Integration Services Backward Compatibility."
Does that mean that you can't execute a DTS package that was created in SQL 2000 as 64bit using the Execute DTS 2000 package task on a SQL 2005 64bit server?
Or can't execute a DTS package that was created in SQL 2000 as 32bit using the Execute DTS 2000 package task on a SQL 2005 64bit server?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

mark lake Say Hey Kid Points: 702 More actions · Answer 1

Although I have not encountered this particular issue on my 64 bit infrastructure (we got rid of all our DTS') I have come across a bucket load of 64 Vs 32 bit issues. Mostly surrounding drivers and especially Oracle connections.

My solution was to have a 32 bit server running as a companion job server to my main 64 bit environment, not sure if it'll help you or if it's feasible... but that's just what I've found.

davidsalazar01 SSCarpal Tunnel Points: 4072 More actions · Answer 2

Mark,

I don't have any heterogeneous connections to Oracle/Sybase, etc. They are all native SQL connections and data load packages.

So you're saying that I could have a companion SQL 2000 server that will execute the DTS packages against the SQL 2005 64bit server? Or should I just revert back to SQL 2005 32bit instead?

I having a real hard time with this. I can't believe that you can't take 32bit packages from 2000 and port them over to a SQL 2005 64bit server that we just spent a ton of money on.

Thanks,

Dave

Jpotucek SSCoach Points: 18583 More actions · Answer 3

Did you ever find a solution for this? I am currently going from a 2005 32 bit environment with legacy DTS packages to a 2005 64 bit instance.