Workflow for Running DTS Tasks

You run the DTS import tasks in sequence so fact data is imported first, and then dimension data.

The following figure shows the order in which you must run the Commerce Server DTS tasks to import and transform data in the Data Warehouse.

Notes

• You can manually configure the Commerce Server DTS tasks to import data, or you can use the Data Warehouse Import Wizard. For more information about the wizard, see Data Warehouse Import Wizard.

• Always run the DTS tasks in sequence. Never run two DTS tasks (or multiple instances of one task) at the same time against the same Data Warehouse.

  If two DTS tasks run at the same time, the data in the Data Warehouse will be corrupted.

• You must run the Configuration Synchronization DTS task and the Report Preparation DTS task, regardless of which other import DTS tasks you choose to run.

See Also

Best Practices for the Data Warehouse

Extract, Transform, and Load Processes for DTS Tasks

Extending the Data Warehouse

Data Warehouse Schema

Data Warehouse, Analysis, and OLE DB Provider

Securing the Data Warehouse

Securing Reports

Multiple Sites and One Data Warehouse

Copyright © 2005 Microsoft Corporation.
All rights reserved.