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

How to Install SQL Server 2000

How To

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

To send a 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, type a label that identifies the task on the design sheet.

  3. In the Message list, click Receive messages.

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

  5. Click Add, and then in the Message type list, select a type of message queue and configure each message:
    • Select String Message, and in the String Message box, type the message.

    • Select Data File Message, and in the File Name box, type the path of the file to send the message to, or click the browse (...) button to locate the file.

    • Select Global Variables Message. To add an existing package global variable, click New, and then in the name list, click a global variable. To create a global variable that does not exist in the package for use as a message, click Create Global Variables.