What to look for when migrating DTS packages?

Last Post 26 Oct 2007 10:00 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
nathansneely
New Member
New Member

--
26 Oct 2007 08:23 AM
I have been tasked with migrating/recreating our DTS packages from our old 2000 server to our all ready existing and in production 2005 server.

I recently managed to create a simple SSIS package that connected to an Oracle database and dumped the data into the local MS SQL server. That is the extent of my knowledge of SSIS packages.

I have done a little bit of research and so far it sounds like it will be a pain in the butt to do the migration.

One thing I have read from a SAMS book is that migrating a DTS package that uses ActiveX will not work but then later on in the chapter it suggests that there is a possibility that migrating a DTS package that uses ActiveX could work. Which is it?

Can someone give some general advice on how I should go about doing this?
SQLUSA
New Member
New Member

--
26 Oct 2007 10:00 AM
Here is an MS article on the subject: http://msdn2.microsoft.com/en-us/li...43501.aspx



Acceptable Use Policy
---