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

In this step, you create a package that contains all the Commerce Server DTS tasks necessary to import data into the Data Warehouse and prepare it for analysis. You perform each of the following steps:

  1. Create a package and add the Configuration synchronization task.

  2. Add the Web server log import task.

  3. Add the Transaction data import task.

  4. Add the Catalog data import task.

  5. Add the Profile data import task.

  6. Add the Campaign data import task.

  7. Add the Report preparation task.

  8. Save the package.

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 these tasks. For more information, see the individual topics.

To create a package and add the Configuration synchronization task

  1. Expand Microsoft SQL Servers, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.

  2. Right-click Data Transformation Services, and then click New Package.

  3. On the Task menu, click Configuration synchronization (Commerce Server).

  4. In the Synchronize DW Properties dialog box, do the following:

    Use this

    To do this

    Description

    Type a description for the task.

    Operation level

    Select Site level from the drop-down list.

    Site name

    Select from the drop-down list the site that you want to synchronize with the Data Warehouse.

  5. In the Retry Properties section, do the following:

    Use this

    To do this

    Number of retries

    Type the number of times you want the task to retry connection failures to the Data Warehouse. The default number of retry attempts is 10.

    Seconds between retries

    Type the number of seconds you want the task to wait between retry attempts. The default time interval is 30 seconds.

  6. Click OK.

To add the Web server log import task

  1. On the Task menu, click Web server log import (Commerce Server).

  2. In the Import Web Server Logs dialog box, do the following:

    Use this

    To do this

    Description

    Type a description for the task. The maximum number of characters for the description is 255.

    Operation level

    Select Site level from the drop-down list.

    Site name

    Select from the drop-down list the site that contains the log file that you want to import.

    Log file path

    Type the path of the Web log file that you want to import, or click the ellipsis button […] to browse for the log file path.

    Log Files

    Click to open the Web Server Log Files dialog box, select the Web log files you want to import from the Web Server Log Files list, and then click OK to return to the Import Web Server Logs dialog box.

    Import all log files since last import

    Select this option to specify that all log files created since the last import will be imported.

  3. In the Retry Properties section, do the following:

    Use this

    To do this

    Number of retries

    Type the number of times you want the task to retry connection failures to the Data Warehouse. The default number of retry attempts is 10.

    Seconds between retries

    Type the number of seconds you want the task to wait between retry attempts. The default time interval is 30 seconds.

  4. Click OK.

To add the Transaction data import task

  1. On the Task menu, click Transaction data import (Commerce Server).

  2. In the Transaction Import Properties dialog box, on the General tab, do the following:

    Use this

    To do this

    Description

    Type a description for the task. The maximum number of characters for the description is 255.

    Operation level

    Select Site level from the drop-down list.

    Site name

    Select from the drop-down list the site that contains the data that you want to import.

    Incremental load

    Select this option to import only new transaction data (based on a previous import).

    Full load

    Select this option to import all transaction data.

  3. In the Retry Properties section, do the following:

    Use this

    To do this

    Number of retries

    Type the number of times you want the task to retry connection failures to the Data Warehouse. The default number of retry attempts is 10.

    Seconds between retries

    Type the number of seconds you want the task to wait between retry attempts. The default time interval is 30 seconds.

  4. Click OK.

To add the Catalog data import task

  1. On the Task menu, click Catalog data import (Commerce Server).

  2. In the Catalog Import Properties dialog box, do the following:

    Use this

    To do this

    Description

    Type a description for the task. The maximum number of characters for the description is 255.

    Operation level

    Select Site level from the drop-down list.

    Site name

    Select from the drop-down list the site that contains the data that you want to import.

    Incremental load

    Select this option to import only new catalog data based on a previous import.

    Full load

    Select this option to import all catalog data.

  3. In the Retry Properties section, do the following:

    Use this

    To do this

    Number of retries

    Type the number of times you want the task to retry connection failures to the Data Warehouse. The default number of retry attempts is 10.

    Seconds between retries

    Type the number of seconds you want the task to wait between retry attempts. The default time interval is 30 seconds.

  4. Click OK.

To add the Profile data import task

  1. On the Task menu, click Profile data import (Commerce Server).

  2. In the Profile Import Properties dialog box, do the following:

    Use this

    To do this

    Description

    Type a description for the task. The maximum number of characters for the description is 255.

    Operation level

    Select Site level from the drop-down list.

    Site name

    Select from the drop-down list the site that contains the data that you want to import.

    Query interval (mins.)

    Type the time interval for the import. User data is imported in time intervals to prevent locking the database table. For example, a Web site that has 10,000 users would import user data in 15-minute intervals.

    Setting a smaller value will lock the table for a shorter duration but will increase the number of queries against the table and therefore increase the time the task takes to run. Setting the value to zero will run a single query, locking the table for the entire duration of import but can degrade site performance.

    Import start date

    Select from the drop-down calendar a date on which to begin your import.

    Incremental load

    Select this option to import only new users based on a previous import.

    Full load

    Select this option to import all user data.

  3. In the Retry Properties section, do the following:

    Use this

    To do this

    Number of retries

    Type the number of times you want the task to retry connection failures to the Data Warehouse. The default number of retry attempts is 10.

    Seconds between retries

    Type the number of seconds you want the task to wait between retry attempts. The default time interval is 30 seconds.

  4. Click OK.

To add the Campaign data import task

  1. On the Task menu, click Campaign data import (Commerce Server).

  2. In the Campaign Import Properties dialog box, do the following:

    Use this

    To do this

    Description

    Type a description for the task. The maximum number of characters for the description is 255.

    Operation level

    Select Site level from the drop-down list.

    Site name

    Select from the drop-down list the site that contains the data that you want to import.

  3. In the Retry Properties section, do the following:

    Use this

    To do this

    Number of retries

    Type the number of times you want the task to retry connection failures to the Data Warehouse. The default number of retry attempts is 10.

    Seconds between retries

    Type the number of seconds you want the task to wait between retry attempts. The default time interval is 30 seconds.

  4. Click OK.

To add the Report preparation task

  1. On the Task menu, click Report preparation (Commerce Server).

  2. In the Prepare Reports Properties dialog box, do the following:

    Use this

    To do this

    Description

    Type a description for the task. The maximum number of characters for the description is 255.

    Site name

    Select the site for which you are populating the OLAP cubes.

    Incremental

    Select to process the OLAP cubes incrementally.

    Full

    Select to process the OLAP cubes in their entirety.

  3. Click OK.

To save the package

  1. On the Package menu, click Save.

  2. In the Save DTS Package dialog box, in the Package name box, type a name for the package (such as <SiteName>Import).

  3. Click OK.

    The package that contains the task is saved.

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