DTS Designer Example: A Completed DTS Package
Data Transformation Services (SQL Server 2000)
DTS Designer Example: A Completed DTS Package

DTS Designer Example: A Completed DTS Package

  New Information - SQL Server 2000 SP3.

The following diagram shows a completed Data Transformation Services (DTS) package on the DTS Designer design sheet. The graphical objects on the design sheet represent connections, tasks, and precedence constraints.

The following is a description of the graphical objects:

  • A connection to a text file containing source data (the Text File (Source) icon) and a second connection to a destination, the Northwind database (the Northwind icon).

    Security Note  When possible, use Windows Authentication.

  • A Transform Data task (the gray arrow) that defines the data being copied and transformed.

  • Two precedence constraints (striped arrows) that further designate workflow:
    • If the package is run and the data is copied successfully from the text file to an instance of Microsoft® SQL Server™, an index is created on the table to which the data is copied (the striped arrow from the Northwind icon to the Create Index icon).

    • If the package is run and the data copy fails, an e-mail is sent to a database administrator (the striped arrow from the Northwind data icon to the Send Mail task icon).
  • A text annotation (the label "Customer Update, Chicago").
Page view tracker