Step 2: Add Workflow Instructions

  • Article

In this step, you will reopen the package you created in Step 1, and add workflow instructions that control the order in which the tasks in the package will be run.

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

  2. Expand Data Transformation Services, and then click Local Packages.

  3. Double-click the package you created.

  4. Hold down the CTRL key and click each task in the following order:

    • Configuration synchronization
    • Web server log import
    • Transaction data import
    • Product catalog import
    • Profile data import
    • Campaign data import
    • Report preparation
    • Report caching

  5. On the Workflow menu, click On Completion.

    Workflow instructions are added to the package.

  6. On the Package menu, click Save.

The package is saved with the workflow instructions.

Copyright © 2005 Microsoft Corporation.
All rights reserved.