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

  • Article

In this step, you create a package that contains all of 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 Product catalog import task
  5. Add the Profile data import task
  6. Add the Campaign data import task
  7. Add the Report preparation task
  8. Add the Report caching task
  9. Save the package

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 synchronize task. The maximum number of characters for the description is 255.
    Operation level Select Site level from the drop-down list to synchronize a site with the Data Warehouse.
    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.

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 this import 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 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.

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 import 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 name of the Web site that contains the log file you are importing.
    Log file path Type the path of the Web log file you want to import, or click Ellipsis 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.

Add the Product catalog import task

  1. On the Task menu, click Product catalog import (Commerce Server).
  2. In the Catalog Import Properties dialog box, do the following:
    Use this To do this
    Description Type a description for this import 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 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.

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 this import 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 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 with 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 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.

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 this import 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 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.

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 of the Report preparation 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.

Add the Report caching task

  1. On the Task menu, click Report caching (Commerce Server).
  2. In the Cache Warmer Properties dialog box, do the following:
    Use this To do this
    Description Type a description of the Report caching 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.

Save the package

  1. On the Package menu, click Save.
  2. In the Save DTS Package dialog box, in the Packagename box, type a name for the package, such as <site name>Import.
  3. Click OK.

The package containing the task is saved.

Copyright © 2005 Microsoft Corporation.
All rights reserved.