How to configure the Ask For Facts task (Enterprise Manager)

How to configure the Ask For Facts task (Enterprise Manager)

To configure the Ask For Facts 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 Ask For Facts.
   
   
3. In the Message box, click Send Message.
   
   
4. In the Queue box, enter the name of the computer_name\queue_type$\queue_name combination that identifies the location to which these messages will be sent.
   
   
5. Under Messages to be sent, click New, and then in the Message type box, click String Message.
   
   
6. In the String Message box, type Summarize shipments.
   
   
7. On the design sheet, right-click Ask For Facts, point to Workflow, and then click Workflow Properties.
   
   
8. Click the Options tab, and then clear the following check boxes:
   • Join transaction if present
     
     
   • Commit transaction on successful completion of this step
     
     
   • Rollback transaction on failure