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:
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
To execute a DTS package from the DTS Import/Export Wizard
You can execute a package from the Data Transformation Services node of the SQL Server Enterprise Manager console tree. You do not have to open the package to execute it.
To execute a DTS package from SQL Server Enterprise Manager
You also can run packages by:
To execute a DTS package using the DTS Run utility
To execute a DTS package using dtsrun
DTS Package Execution Utilities