How to configure the Log Bad Update task (Enterprise Manager)

How to configure the Log Bad Update task (Enterprise Manager)

To configure the Log Bad Update task

1. From the Task toolbar, drag a Message Queue task onto the Data Transformation Services (DTS) design sheet.
   
   
2. In the Message Queue Task Properties dialog box, in the Description box, type Log Bad Update.
   
   
3. In the Message list, click Send Messages.
   
   
4. In the Queue box, enter the name of the computer_name\queue_type$\queue_name combination that identifies the location to which bad update messages will be sent.
   
   
5. Click Add, and then in the Message type list, click Global Variables Message.
   
   
6. Add the global variables ID and Name by doing the following:
   1. Click Create Global Variables.
      
      
   2. In the Global Variables dialog box, type ID under a blank entry in the Variables list, then click New to create a new entry and enter Name.
      
      
   3. In the Message Queue Message Properties dialog box, click New, click in the box under Name, and then select ID from the list. Repeat this step for the global variable Name.

      Note  Entries for Type and Value have no effect in this application. You do not need to enter values.

7. On the design sheet, right-click Log Bad Update, point to Workflow, and then click Workflow Properties.
   
   
8. Click the Options tab, and then do the following:
   • Select the Join transaction if present check box.
     
     
   • Select the Commit transaction on successful completion of this step check box.
     
     
   • Clear the Rollback transaction on failure check box.
9. Click the Precedence tab, and then add a new entry with Source Step set to Insert One Employee and Precedence set to Failure.