Working with legacy DTS Packages with SQL Server 2005
November 12th, 2008
Users of SQL Server 2005 already know DTS Packages have been set aside for the newer, more functional, SSIS (SQL Server Integration Services). But if you are anything like myself, you have dozens of old DTS Packages and no desire to upgrade them. Send to the rescue The Microsoft SQL Server 2005 Feature Pack; you will want to Download the Microsoft SQL Server 2000 DTS Designer Components add-on.
- X86 Package (SQLServer2005_DTS.msi) – 5088 KB
After install you will find a Legacy tab in the Object Explorer of SQL Server Management Studio. Expand this, select Data Transformation Services, find your DTS and double click. Behold the old DTS Designer of SQL Server 2000! whoo hoo.
Note:
The complete package is available here.
Related posts:
- Working with SSRS 2005 Recently asked to replace Crystal Reporting Services with SQL Server...
- DTS in Sql Server 2008 If you manage lots of SQL Servers no doubt you...
Oh, freaking sweet! I hate using SSIS, not that they are bad, they are just over kill for most of what I need to do. This is perfect, I’m going to have to give it a shot later on today.