Executing a DTS Package

When you run a Data Transformation Services (DTS) package, all of its connections, tasks, transformations, and scripting code are executed in the sequence described by the package workflow.

You can execute a package from:

• Within a DTS tool.
  
  
• SQL Server Enterprise Manager.
  
  
• Package execution utilities.

Executing a Package from a DTS Tool

You can execute a package in DTS Designer after creating or editing a package or in the DTS Import/Export Wizard after creating a package.

When you run a package in DTS Designer or the DTS Import/Export Wizard, a summary status of the execution progress and execution status of all the steps in the package is displayed. You can check the status of each step and gather information on steps that failed to execute successfully.

Note  You also can view the status of step execution when you use the DTS Run utility.

To execute a DTS package from DTS Designer