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

  1. Click Start, point to Programs, point to SQL Server, and then click SQL Server Management Studio.

  2. In the Object Explorer pane, expand the Management node, and then expand the Legacy node.

  3. The Data Transformation Services node opens in the right pane.

    From here, you can run the DTS and data management tasks.

See Also

Other Resources

Managing the Data Warehouse

ETL Processing for DTS Tasks

Running the DTS Tasks

Deleting Data from the Data Warehouse

Creating and Running a Multi-task Package