Running the Campaign Data Import DTS Task

  • Article

You use the Campaign data import DTS task to import campaign data. Campaign data includes advertisers, advertisement campaigns, and campaign item information. After you run the Campaign data import task, business managers can run reports on the imported campaign data, and analyze the success of the campaigns.

Ee796985.note(en-US,CS.20).gifNote

  • If you are importing only new data for Campaign reports, run the Web server log import DTS task first, and then run the Campaign data import task. For information about running the Web server log import DTS task, see Running the Web Server Log Import DTS Task.

To import campaign data for a site into your Data Warehouse

To import campaign data for all associated sites into your Data Warehouse

To import campaign data for a site into your Data Warehouse

  1. Run the Configuration synchronization DTS task to synchronize your site configuration with the Data Warehouse. For instructions, see Running the Configuration Synchronization DTS Task.

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

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

    Alternatively, if you are changing an existing package, right-click Data Transformation Services, click All Tasks, and then select Open Package. In the Select File dialog box, click the package you want to change, and then click Open.

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

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

    Use this To do this
    Description Type a description for this import task.
    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.

  6. 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.
    Second between retries Type the amount of time you want the task to wait between retry attempts. The default time interval is 30 seconds.

  7. Click OK.

    Ee796985.note(en-US,CS.20).gif Note

    • You can add multiple DTS tasks to a package, add sequencing or workflow information, and then run all the tasks in the package.

  8. On the Package menu, click Execute.

    The Executing Package dialog box appears, showing the progress of your import. When the import process is complete, the Package Execution Results dialog box informs you that it completed successfully.

  9. Click OK, and then click Done.

    Campaign data is imported into the Data Warehouse.

  10. Run the Report preparation DTS task to organize the imported data into the designated OLAP cubes. For instructions about running the Report preparation task, see Running the Report Preparation DTS Task.

To import campaign data for all associated sites into your Data Warehouse

  1. Expand Microsoft SQL Server, 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.

    Alternatively, if you are changing an existing package, right-click Data Transformation Services, click All Tasks, and then select Open Package. In the Select File dialog box, click the package you want to change, and then click Open.

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

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

    Use this To do this
    Description Type a description for this import task.
    Operation level Select Data Warehouse level from the drop-down list.
    Data Warehouse name Select from the drop-down list the Data Warehouse associated with the sites for which you want to import campaign data.

  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 amount of time you want the task to wait between retry attempts. The default time interval is 30 seconds.

  6. Click OK.

    Ee796985.note(en-US,CS.20).gif Note

    • You can add multiple DTS tasks to a package, add sequencing or workflow information, and then run all the tasks in the package.

  7. On the Package menu, click Execute.

    The Executing Package dialog box appears, showing the progress of your import. When the import process is complete, the Package Execution Results dialog box informs you that it completed successfully.

  8. Click OK, and then click Done.

    Campaign data is imported into the Data Warehouse.

  9. Run the Report preparation DTS task to organize the imported data into the designated OLAP cubes and make it available for reports. For instructions about running this task, see Running the Report Preparation DTS Task.

This data is now available for reports.

See Also

Running the Campaign Data Import DTS Task

ETL Process for the Campaign Data Import DTS Task

Scripting for the Campaign Data Import DTS Task

Best Practices for Data Warehouse

Specifying Data to be Imported into the Data Warehouse

Workflow for Running the DTS Tasks

Troubleshooting the Data Warehouse Import Process

Copyright © 2005 Microsoft Corporation.
All rights reserved.