Export (0) Print
Expand All

Executing a DTS Package

SQL Server 2000

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

Enterprise Manager

To execute a DTS package from the DTS Import/Export Wizard

Enterprise Manager

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

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

Enterprise Manager

To execute a DTS package using dtsrun

Enterprise Manager

See Also

DTS Package Execution Utilities

dtsrun Utility

Executing DTS Packages in Visual Basic

Scheduling a DTS Package for Execution

Show:
© 2014 Microsoft