How to Configure and Run DTS Tasks with SQL Server
In SQL Server, the Data Transformation Services (DTS) tasks are in the Data Transformation Services node. Use the following steps to open the Data Transformation Services node.
To run the DTS tasks in SQL Server
Click Start, point to Programs, point to SQL Server, and then click SQL Server Management Studio.
In the Object Explorer pane, expand the Management node, and then expand the Legacy node.
The Data Transformation Services node opens in the right pane.
From here, you can run the DTS and data management tasks.