DTS Designer Example: A Completed DTS Package
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).
- 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).
- 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).
- A text annotation (the label "Customer Update, Chicago").