How to receive a Data File Message with the Message Queue task (Enterprise Manager)

How to Install SQL Server 2000

How To

How to receive a Data File Message with the Message Queue task (Enterprise Manager)

To receive a data file 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 Data File Message.

  6. In the Save file as box, enter the path of a file or directory on your computer, or click the browse (...) button to locate the file.

  7. Under Only receive message from a specific package or version, click a filter option.

  8. If you select From package or From version, set Identifier to the globally unique identifier (GUID) string that identifies the proper DTS package or version. Use the browse (...) button to search for available packages and versions.

  9. 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 value can range from 1 through 9999 (in seconds).