Creating a Package with DTS Designer

The following example shows you how to build, configure, execute, and save a Data Transformation Services (DTS) package.

To create a DTS package using DTS Designer

Enterprise Manager

To configure and execute a DTS package

Choose a source.

Drag an object from the Connection toolbar to the DTS Designer design sheet, and then configure the data source in the Connection Properties dialog box.

Choose a destination.

Drag an object from the Connection toolbar to the design sheet and then configure the data source in the Connection Properties dialog box.

Draw a line between the source and destination.

Click the data source icon, press CTRL, and then click the destination icon. Right-click the destination icon, and then click Transform Data Task. At this point, a line appears to show the data flow from the source to the destination.

Specify what data to move and how you want it to be transformed.

Double-click on the line connecting the source to the destination. In the Transform Data Task Properties dialog box, on the Source tab, you can choose a source table or build a query with the DTS Query Designer. On the Destination tab, you can choose an existing table or create a new table. On the Transform tab, you can copy or transform the data.

For more information, see DTS Query Designer.

Save the package to SQL Server 2000 Meta Data Services, SQL Server, a structured storage file, or a Microsoft Visual Basic® file.

If your package is saved to Meta Data Services, you can use the data lineage feature to determine where your data came from on a row-by-row basis.

Execute the package.

In the toolbar, click Execute.

Creating a Package with DTS Designer

See Also