How to design and run SQL 2000 Server Data Transformation Services (DTS) packages from SQL Server 2005

You can design, edit and run DTS (Data Transformation Services) packages that you have created on a MS SQL Server 2000 from a MS SQL 2005 Server by the help of Microsoft SQL Server 2000 DTS Designer Components.

You can download Microsoft SQL Server 2000 DTS Designer Components from the Microsoft Downloads site from the url : Microsoft Downloads Portal

SQL Server 2005 developers and administrators can use DTS Designer Components as a design tool to edit and maintain existing DTS packages.
Downloaded file SQLServer2005_DTS.msi has a size of 5 MB. During installation the SQL Server Enterprise Manager should be kept closed. After installation of DTS Designer Components, SQL Server 2005 developers and administrators can use this designer tool to edit, maintain and run the previously created in Microsoft SQL Server 2000 DTS packages from the Object Explorer in SQL Server 2005 Management Studio.
If you drill through the Management > Legacy > Data Transformation Services path you can import the existing DTS packages in .dts file format that are exported from the MS SQL Server 2000.
And after import you can open the designer tool by opening the context menu on the DTS packege item. You can open a specific version of a DTS package.