Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Creating a Package with DTS Designer

SQL Server 2000

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

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. Execute the package.

In the toolbar, click Execute.

Note  When you attempt to close the DTS Designer without first saving the changes to a package, an alert appears that gives you the option of saving or not saving the changes. Either action closes the DTS Designer. There is no option to cancel and remain in the DTS Designer.

See Also

DTS Designer Example: A Completed DTS Package

Show:
© 2015 Microsoft