How to Run an Import DTS Package

If you create an import DTS package using the Data Warehouse Import Wizard, you might decide to save it to SQL Server so that you can run it later. Perform the following procedure to run the import package.

To run an import package on SQL Server 2005

  1. In Microsoft SQL Server Management Studio, expand Management, and then expand Legacy.

  2. Expand Data Transformation Services, and then click Local Packages.

  3. Right-click your DTS package, and then click Execute Package.

  4. Review the Executing Package window for failed tasks.

    Note

    If any part of your DTS tasks failed, an error message will appear.

  5. Click OK to close the error message.

See Also

Other Resources

Importing Data into the Data Warehouse