Creating a DTS Package

To create a DTS package using Visual Basic or C++

1. Create a Package object.
2. Create a Connections collection for the package.
3. Add one or more Connection objects to the Package object’s Connections collection.
4. Create a Tasks collection.
5. Add one or more Task objects to the Package object’s Tasks collection.

• If the Task object is a ExecuteSQLTask, DataPumpTask, or DataDrivenQueryTask object, it must reference one or more Connection objects.
• If Task object is a DataPumpTask or a DataDrivenQueryTask object:
  1. Add one or more Transformation objects to the Task object’s Transformations collection.
  2. Add one or more Column objects to the Transformation object’s source or destination Columns collection.

6. Add one or more Step objects to the Package object’s Steps collection. Note that each Step object must reference one Task object using the Step.TaskName property.

To control the sequence of program execution, add one or more Precedence constraints (based on a previous Step object) to the Step object’s PrecedenceConstraints collection.