Step 2: Add Workflow Instructions
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.
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 this task. For more information, see the individual topics.
To add workflow instructions
If you are using SQL Server 2005, do the following:
Click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
In SQL Server Management Studio, in the Object Explorer pane, expand the server on which your Data Warehouse is installed, expand Management, expand Legacy, and then expand Data Transformation Services.
Right-click the package that contains the tasks that you want to run, and then click Open.
In the DTS Package or DTS 2000 Package Designer window, hold down the CTRL key and then click each task in the following order:
Configuration synchronization
Web server log import
Transaction data import
Catalog data import
Profile data import
Campaign data import
Report preparation
On the Workflow menu, click On Completion.
Workflow instructions are added to the package.
On the Package menu, click Save.
The package is saved with the workflow instructions.
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