April 20, 2009 at 9:43 am
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
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 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
Greg - thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply