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
To execute a DTS package from the DTS Import/Export Wizard
Executing a Package from Enterprise Manager
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
Executing a Package from Other Tools
You also can run packages by:
- Issuing dtsrun command prompt utility from the command prompt. This utility includes a variety of command switches you can use for customizing the execution of a package.
- Using the DTS Run utility. This utility, presented through a set of dialog boxes, offers a subset of the most common execution options available with dtsrun.
To execute a DTS package using the DTS Run utility
To execute a DTS package using dtsrun