Scripting DTS Tasks

Commerce Server 2009 R2 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=75137.

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

• Scripting the Configuration Synchronization DTS Task

• Scripting the Web Server Log Import DTS Task

• Scripting the Transaction Data Import DTS Task

• Scripting the Product Catalog Import DTS Task

• Scripting the Profile Data Import DTS Task

• Scripting the Campaign Data Import DTS Task

• Scripting the Data Deletion DTS Task

• Scripting the IP Resolution DTS Task

• Scripting the Report Preparation DTS Task

See Also

Other Resources

Commerce Server DTS Tasks

Developing with the Data Warehouse Analytics System