How to configure the Wait For Trigger task (Enterprise Manager)

How to Install SQL Server 2000

How To

How to configure the Wait For Trigger task (Enterprise Manager)

To configure the Wait For Trigger 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 Wait for Trigger.

  3. In the Message list, click Receive Message. In the Queue box, enter the same computer_name\queue_type$\queue_name combination as that entered for the Ask for Facts task.

  4. In the Message type list, click String Message.

  5. Under Compare, click Exact Match, and then in the Compare String box, type Summarize shipments.

  6. Select the Remove from message queue check box.

  7. On the design sheet, right-click Wait for Trigger, point to Workflow, and then click Workflow Properties.

  8. In the Workflow Properties dialog box, 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