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:
- DTS in Sql Server 2008 If you manage lots of SQL Servers no doubt you...
- Restarting Terminal Services Remotely If you find yourself using terminal services a lot to...
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.