Scripting DTS Tasks

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

Commerce Server Data Transformation Services (DTS) tasks import and change data in the Data Warehouse. You can run the DTS tasks by using SQL Server, or you can develop scripts to create and run the tasks by using the command line. Site developers and system administrators can automate the creation and scheduling of DTS packages for each new client, and minimize the time that is needed to run the tasks.

Each script creates a package for each DTS task. Multiple tasks can be loaded into a single package. For more information about how to create multitask DTS packages, see https://go.microsoft.com/fwlink/?LinkId=7513.

Certain DTS tasks extend database tables during the configuration and execution of the task. The SQL Server operations that are involved in extending the database tables require the user to be in the appropriate SQL role. For more information about user roles, see What Are the Required Database Accounts and Database Role Mappings?

To import data into the Data Warehouse, run the DTS tasks in the following order:

  1. Configuration Synchronization

  2. Web Server Log Import

  3. Transaction Data Import

  4. Product Catalog Import

  5. Profile Data Import

  6. Campaign Data Import

  7. Data Deletion

  8. IP Resolution

  9. Report Preparation

In This Section

See Also

Other Resources

Commerce Server DTS Tasks

Developing with the Data Warehouse Analytics System