Migrating DTS to SSIS

• dva2007

  SSCertifiable

  Points: 7707

  More actions

  September 23, 2008 at 4:30 am

  #198375

  Hello friends,

  We are migrating from SQL 2000 to SQL Server 2005 and need to migrate from DTS to SSIS. How easy it is? I just need view about how i can do it and migration wizard can do it for all or not? I have just read for some of them it will work in migration wizard and some will not.

  Is there any useful graphical article which i can refer for migration?

  Please let me know about this.

  thanks,

  Vijay

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  September 23, 2008 at 11:47 am

  #875935

  I recommend running SQL Server 2005 Upgrade Advisor to see which packages will migrate easily and which will need to be rewritten.

  Some articles that have helped me:

  http://msdn.microsoft.com/en-us/library/cc768544.aspx

  http://msdn.microsoft.com/en-us/library/ms143501.aspx

  Greg