Creating and Running a Multi-task Package

This section contains steps that describe how to create a single, reusable SQL Server DTS package that contains all the tasks that it needs in order to import data into the Data Warehouse. Additionally, the package will contain workflow instructions so that the tasks run in the correct order. The package will be stored for reuse, and scheduled to run automatically.

You can use the Data Warehouse resource to create packages that contains the following:

• DTS tasks

• Workflow instructions

After you create a package that contains DTS tasks and workflow instructions, you can store the package and reuse it. You can run a stored package manually or schedule it to be run automatically.

This example makes the following assumptions:

• You will import data for a single site in the Data Warehouse.

• You previously imported each type of the data for the site into the Data Warehouse.

In This Section

• Step 1: Create a Package Containing the Commerce Server DTS Tasks

• Step 2: Add Workflow Instructions

• Step 3: Execute the Package and Check for Errors

• Step 4: Schedule the Package for Automatic Execution