Share via

Message Queue Task Editor (Send Page)

  • Article

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.

Options

  • 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.

    Note

    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.

    Important

    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.

MessageType Dynamic Options

MessageType = Data file message

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

MessageType = Variable message

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

    Related Topics: Select Variables

MessageType = String message

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

See Also

Reference

Message Queue Task Editor (General Page)

Message Queue Task Editor (Receive Page)

Expressions Page

Concepts

Integration Services Error and Message Reference