Export (0) Print
Expand All

Message Queue Task Editor (Send Page)

 

Use the Send page of the Message Queue Task Editor dialog box to configure a Message Queue task to send messages from a Microsoft SQL Server Integration Services package.

To learn about this task, see Message Queue Task.

UseEncryption

Indicate whether to encrypt the message. The default is False.

EncryptionAlgorithm

If you choose to use encryption, specify the name of the encryption algorithm to use. The Message Queue task can use the RC2 and RC4 algorithms. The default is RC2.

System_CAPS_noteNote

The RC4 algorithm is only supported for backward compatibility. New material can only be encrypted using RC4 or RC4_128 when the database is in compatibility level 90 or 100. (Not recommended.) Use a newer algorithm such as one of the AES algorithms instead. In the current release of SQL Server, material encrypted using RC4 or RC4_128 can be decrypted in any compatibility level.

System_CAPS_importantImportant

These are the encryption algorithms that the Message Queuing (also known as MSMQ) technology supports. Both of these encryption algorithms are now considered cryptographically weak compared to newer algorithms, which Message Queuing does not yet support. Therefore, you should consider your cryptography needs carefully when sending messages using the Message Queue task.

MessageType

Select the message type. This property has the options listed in the following table.

Value

Description

Data file message

The message is stored in a file. Selecting the value displays the dynamic option, DataFileMessage.

Variable message

The message is stored in a variable. Selecting the value displays the dynamic option, VariableMessage.

String message

The message is stored in the Message Queue task. Selecting the value displays the dynamic option, StringMessage.

DataFileMessage

Type the path of the data file, or click the ellipsis (…) and then locate the file.

VariableMessage

Type the variable names, or click the ellipsis (…) and then select the variables. Variables are separated by commas.

Related Topics: Select Variables

StringMessage

Type the string message, or click the ellipsis (…) and then type the message in the Enter String Message dialog box.

Show:
© 2015 Microsoft