Friday, March 16, 2007

Editing SQL Server 2000's DTS packages in SQL Server 2005

In MS SQL Server 2005, DTS was replaced with SSIS.
Fortunately, Microsoft appreciates the cost and effort spent by companies and DBAs to create DTS packages. So SSIS has (Execute DTS 2000 Package) task.
This is great, But what if you want to make a small edit to the DTS package after migrating to the new version of SQL Server?
You have 2 options:
  1. Import the DTS package to SSIS, it's relatively easy. And although I had minor problems when trying this, the process was successful.
  2. If you don't want to migrate to SSIS, Microsoft provided a good download in its SQL Server 2005 feature pack called Microsoft SQL Server 2000 DTS Designer Components. which can be used to edit and save DTS packages using the same interface used in SQL Server 2000 and save it. A really good one from Microsoft!!.


Anonymous said...

i have downloaded and installed the Microsoft SQL Server 2000 DTS Designer Components in my system, now tell me how can i edit and save my dts package in sql 2005 ms studio?

Hesham A. Amin said...

You can open BIDS (SQL Server Business Intelligence Development Studio) and create a new "Integration services project".
In the new project, right click "SSIS Packages" and click "Migrate DTS 2000 Package".

Retrovit ID said...
This comment has been removed by a blog administrator.