How to migrate DTS packages from SQL 2000 to SQL 2008R2

• psred

  SSCrazy

  Points: 2049

  More actions

  August 15, 2013 at 10:33 am

  #296996

  How to migrate DTS packages from SQL 2000 to SQL 2008R2.

  Or atleast let me know how to migrate DTS packages in SQL 2000 to SSIS packages SQL 2008R2

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  August 15, 2013 at 12:15 pm

  #1641895

  Here are some ideas.

  http://blogs.msdn.com/b/psssql/archive/2009/02/19/how-to-copy-dts-2000-packages-between-servers-and-from-sql-2000-to-sql-2005-and-sql-2008.aspx

  I also remember a free tool that migrated them all with only a couple of clicks.

  Maybe it was the DTS BAckup tool mentioned here:

  http://www.sqldts.com/204.aspx