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.