How to configure one Loop task (Enterprise Manager)

How to configure one Loop task (Enterprise Manager)

To configure one Loop task

1. On the Data Transformation Services (DTS) design sheet, right-click New Employee, point to Workflow, and then click Workflow Properties.
   
   
2. In the Workflow Properties dialog box, click the Options tab and note the name of the step in the Name box.

   It is likely to be DTSStep_DTSMessageQueueTask_1. You will need to click this name in another box later in this procedure.

3. From the Task toolbar, drag a Dynamic Properties task onto the design sheet.
   
   
4. In the Dynamic Properties Task Properties dialog box, in the Description box, type Loop, and then click Add.
   
   
5. In the tree display in the left pane, expand Steps, and then expand DTSStep_DTSMessageQueueTask_1 (the name you noted in Step 2).
   
   
6. In the right pane, under Property name, double-click ExecutionStatus.
   
   
7. In the Add/Edit Assignment dialog box, in the Source list, click Constant, and then in the Constant box, type 1.

   1 is the value assigned to DTSStepExecStat_Waiting.

8. On the design sheet, right-click Loop, point to Workflow, and then click Workflow Properties.
   
   
9. Click the Precedence tab, and then add a new entry with Source Step set to either Insert One Employee or Log Bad Update and Precedence set to Success.