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.
Indicate whether to encrypt the message. The default is False.
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.
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.
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.
Select the message type. This property has the options listed in the following table.
Data file message
The message is stored in a file. Selecting the value displays the dynamic option, DataFileMessage.
The message is stored in a variable. Selecting the value displays the dynamic option, VariableMessage.
The message is stored in the Message Queue task. Selecting the value displays the dynamic option, StringMessage.
Type the path of the data file, or click the ellipsis (…) and then locate the file.
Type the variable names, or click the ellipsis (…) and then select the variables. Variables are separated by commas.
Related Topics: Select Variables
Type the string message, or click the ellipsis (…) and then type the message in the Enter String Message dialog box.