Post reply

Migrating to 2005 - dts packages

  • April 20, 2009 at 9:43 am

    #129421

    Do you need to do an in-place upgrade to retain dts packages? Even if I am going to convert them to SSIS, do I have to start with an in-place upgrade?

  • April 24, 2009 at 10:58 am

    #983692

    No, but if you do a side-by-side migration, you'll have to copy the packages from the SQL 2000 instance to the SQL 2005 instance. Here are the methods I've used:

    1. Open each package in DTS Designer and save as a file. In SQL 2004 Management Studio, expand Management, Legacy, right-click on Data Transformation Services and select Import Package File.

    2. Use DTSBackup 2000, a free download from http://www.sqldts.com, to save all packages in an instance to files. Then do the import as described above.

    Greg

  • April 24, 2009 at 12:47 pm

    #983786

    Greg - thanks!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply