Message Queue Task Properties

DTS Designer

DTS Designer Help

Message Queue Task Properties

Use this dialog box to configure a Message Queue task, which allows you to use Message Queuing to send and receive messages between Data Transformation Services (DTS) packages.

Options

Description

Type a text name for the message queue task.

Message

Select whether you want the message queue task to Send messages or Receive messages.

Queue

Specify the queue from which you will send or receive messages. The format for the queue is: computer_name\queue_type$\queue name, where queue_type can be Outgoing, Public, Private, or System.

Send Message Options

If you select Send messages in the Message box, the following options are available:

Messages to be sent
Displays information on each message defined for this message queue task:

Number

View the automatically generated number that designates the order in which a message was created.

Message type

View whether the message consists of a data file, global variable, or string.

Add

Define a new message to add to the message queue task.

Edit

Edit an existing message within the message queue task.

Receive Message Options

If you select Receive messages in the Message box, different options become available depending on the Message type you select:

Message type
Select one of the following message types from the list:

String Message, which contains a text string you specify.

Data File Message, which contains a DTS package ID, a version ID, and the name and contents of a data file.

Global Variables Message, which contains a DTS package ID, a version ID, and the name, type, and value of one or more variables.

Only receive message from a specific package or version
Lets you filter the possible messages the message queue task can receive:

No filter. Select this option to turn message filtering off for the task.

From package. Select this option to specify a package to use as a filter. Only messages from versions of the specified package will be received.

From version. Select this option to specify a package version to use as a filter. Only messages from a package with the specific version identifier will be received.

Identifier. View the globally unique identifier (GUID) of the package or package version to be used as a filter.

... Browse for a package or version to use as a filter for receiving messages.

Save file as
Save the contents of a data file message into the specified file, by typing the file path and name or by browsing for a file in which to save the contents of a data file message.
Compare
Specify a filter to use when receiving a string message. The string message is not received by the Message Queue task unless it matches the filter. Use one of the following:

None, to specify no filter.

Exact match, to specify that the message content must exactly match the string entered in the Compare string box.

Ignore case, to specify that the message content must match that of the string entered in the Compare string box, irrespective of case.

Containing, to specify that the message content must contain the string entered in the Compare string box.

Compare string
Type the string to be used as a filter when evaluating the string message.
Overwrite
Select to overwrite the data in an existing file when saving the contents of a data file message.

Time out after

Select to specify a time-out period in which to receive the message.

See Also

Message Queue Task

Message Types