How to Run an Import DTS Package

  • Article

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

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.

To run an import package on SQL Server 2000

  1. In Microsoft SQL Server Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.

  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 dialog box 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