Post reply

SQL 2000 DTS 32bit packages on SQL 2005 64bit

  • November 8, 2007 at 9:43 am

    #749544

    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.

  • November 8, 2007 at 9:48 am

    #749553

    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

  • August 6, 2010 at 6:28 am

    #1203435

    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.

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

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