Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
Building a Package in the DTS Designer
By Allan Mitchell
Version 7.0/2000
Level Beginner

Why The Tutorial?

The point of this tutorial is to give us an introduction to the DTS designer. If you're serious about DTS or want to explore more of its many features then it won't be long before you end up here. This tutorial was created using SQL Server 2000 but users of SQL Server 7 will still find it useful. Where a feature does not exist in version 7 we'll say so. What are we going to be covering?

1. Explanation of Terminology.

2. Quick Tour of Designer.

3. Adding Connections and Specifying Properties.

4. Creating a Data Pump.

5. Package Properties.