How to receive a string message with the Message Queue task (Enterprise Manager)

How to Install SQL Server 2000

How To

How to receive a string message with the Message Queue task (Enterprise Manager)

To receive a string message with the Message Queue 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, enter a label that identifies the task on the design sheet.

  3. In the Message list, click Receive messages.

  4. In the Queue box, enter the name of the computer_name\queue_type$\queue_name combination that identifies the queue from which you will be reading messages.

  5. In the Message type list, click String message, and then under Compare, click an option for filtering the message.

  6. If you click Exact Match, Ignore Case, or Containing in the Compare String box, type the search text.

  7. Select the Remove from message queue check box to delete any received message from the queue. Clear this check box to leave the message on the queue after task completion.

  8. Clear the Timeout after check box to wait indefinitely for an acceptable message or select the Timeout after check box to enter a timeout interval.

    The timeout interval may take any value from 1 through 9999 (in seconds).