Export (0) Print
Expand All
Expand Minimize

Message Queue Message Properties

SQL Server 2000

Use this dialog box to define the type and content of messages that will be sent to a message queue.

Options

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 Data Transformation Services (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.

Message

Choose whether you want the message queue task to Send messages to other packages or Receive messages from other packages.

String message

Type the text of the message if you selected a Message type of String Message.

File name

Type the path and name of the data file containing the package information.

Global variables

Displays a list of the package global variables that will be sent to the message queue.

Name
After clicking New, select a global variable to include in the message from the list of available package global variables.
Type
View the data type of the selected package global variable.
Value
View the initial value of the selected package global variable.

Create Global Variables

Create new package global variables that you can include in the message queue task.

New

Create a global variable entry to include in the message.

Delete

Delete a global variable entry. Deleting a global variable entry does not delete the global variable definition from the package.

Global variables

Display a list of the global variables that will be sent to the message queue.

See Also

Message Queue Task

Message Types

Show:
© 2014 Microsoft