How do I preserve legacy DTS packages in sql 2005 after uninstall/install

• jdbrown239

  SSCarpal Tunnel

  Points: 4393

  More actions

  January 25, 2013 at 6:54 am

  #267705

  Hi

  I have to uninstall sql server 2005 enterprise edition and then install sql server 2005 standard edition. I have 74 legacy dts packages in the instance. I would like to know the best method of importing the packages back after I install the standard edition.

• jdbrown239

  SSCarpal Tunnel

  Points: 4393

  More actions

  January 29, 2013 at 11:06 am

  #1582267

  This link answered my questions.

  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

• jdbrown239

  SSCarpal Tunnel

  Points: 4393

  More actions

  January 29, 2013 at 1:21 pm

  #1582354

  I have been to that link when I first moved the packages but I got the answer I needed from this link, Thanks

  http://msdn.microsoft.com/en-us/library/ms143706(SQL.90).aspx