The initial example of ms SQL Server DTS application.

This example demonstrates how to use the DTs designer to create a data transmission package.

1. Create a new DTS package first. The method is as follows;

 
2. Click Create to open the designer. For example, the red and blue green boxes in the designer are the labels added to me, which means you can drag the corresponding project from the toolbar on the left, when a task is dragged out, you are prompted to select the source and target. When the task is dragged out, you are prompted to set the connection properties. Double-click the link with an arrow in the middle to define the conversion, in this example, SQL is used to query and select some data from the data source, and then click the target, conversion, and other labels respectively. The default settings are optional;

 

The data has been exported.