November 7, 2007 at 6:35 pm
I'm confused about how to keep existing DTS packages from SQL 2000 and bring them into a new SQL Server 2005 64 bit instance. Does anyone know how to do this? I also have ActiveX scripts in the existing SQL 2000 DTS packages and I've read that ActiveX isn't supported?
Can anyone shed some light on this? DBA/Developer to DBA...:D
November 8, 2007 at 11:51 pm
You're in for a tough journey if you want to run existing dts packages in 2005... let alone a x64 environment.
All depends on complexity and exteral calls.
There is the package migration wizard... have you played with that? Hasn't done us a bit of good. We've found it to save time to rebuild the packages using SSIS.
As I recall, there is a way to call dts packages using a x64 bit version of the dtsrun utility. Search microsoft.... sorry can't provide any more help!
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
November 9, 2007 at 12:39 am
Todd,
Thanks for the input. I ran the migration wizard and it looks like they all imported correctly. But I'm going to go thru them all tomorrow with a developer who created them and see if anything broke. I guess I'll cross my fingers and hope MS doesn't let me down again. 🙂
Thanks again,
-Dave
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply