Share via

How to Configure and Run DTS Tasks with SQL Server 2005

  • Article

In SQL Server 2005, 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 2005

  1. Click Start, point to Programs, point to SQL Server 2005, 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