Data Transformation Services

Sending Messages with the Message Queue Task

Use the Message Queue task to place one or more messages on a queue for later delivery to DTS packages running on this or other computers.

The Message Queue task will fail at run time if:

Important  A Message Queue task is not allowed to take part in the package transaction. As a result, your package will fail at run time if, in the Workflow Properties dialog box for a Message Queue task, you select the Join transaction if present check box.

To send a message with the Message Queue Task

Enterprise Manager

Enterprise Manager