DTS Designer Example: Copying Northwind Data
This example demonstrates how to use Data Transformation Services (DTS) Designer to copy a Northwind database table from the source to the destination. The basic steps are:
- Make two connections, one to the source and a second to the destination.
- Add a Transform Data task that defines a source and destination table and the copying operation to be performed.
- Add an Execute SQL task that checks for the existence of the destination table prior to copying the data. If the table does not exist, it is created. If the table exists, it is dropped and re-created.
- Configure the workflow so the DTS package steps execute in the correct sequence.
- Run the package.
- Save the package so that it can be reused.
Connecting to the Source
Begin by creating a connection to the Northwind database on your local server.
To create a connection to Northwind in DTS Designer