Step 3: Execute the Package and Check for Errors

  • Article

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

In this step, you run the package and verify that all the tasks run correctly.

Note

If you are using SQL Server 2005, you must install DTS 2000 Designer and run the Data Warehouse Import Wizard to create a package. You must have already created a package using the Data Warehouse Import Wizard or have existing packages to import before you can perform this task. For more information, see the individual topics.

To execute the package and check for errors

  1. If you are using SQL Server 2005, do the following:

    1. Click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

    2. In SQL Server Management Studio, in the Object Explorer pane, expand the server on which your Data Warehouse is installed, expand Management, expand Legacy, and then expand Data Transformation Services.

    3. Right-click the package that you want to execute, and then click Open.

    4. In the DTS 2000 Package Designer window, on the Package menu, click Execute.

    5. In the Package Execution Results dialog box informing you that it completed successfully, click OK.

  2. If you are using SQL Server 2000, do the following:

    1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.

    2. In the SQL Server Enterprise Manager console, in the left pane, expand Microsoft SQL Servers, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.

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

    4. Right-click your package, and then click Execute Package.

    5. Check the Executing Package dialog box for failed tasks.

      If any of your tasks failed, an error message will appear. Click OK to close the error message.

  3. In the Executing Package dialog box, click Done.

See Also

Other Resources

How to Run the Configuration Synchronization DTS Task

How to Run the Web Server Log Import DTS Task

How to Run the Catalog Data Import DTS Task

How to Run the Campaign Data Import DTS Task

How to Run the Profile Data Import DTS Task

How to Run the Transaction Data Import DTS Task

How to Run the Data Deletion DTS Task

How to Run the Report Preparation DTS Task

Creating and Running a Multi-task Package