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").