Share via


MSMQ Connection Manager Editor

Use the MSMQ Connection Manager dialog box to specify the path to a Message Queuing (also known as MSMQ) message queue.

To learn more about the MSMQ connection manager, see MSMQ Connection Manager.

Note

The MSMQ Connection Manager supports local public and private queues and remote public queues. It does not support remote private queues. For a workaround that uses the Script Task, see Sending to a Remote Private Message Queue with the Script Task.

Options

  • Name
    Provide a unique name for the MSMQ connection manager in the workflow. The name provided will be displayed within SSIS Designer.
  • Description
    Describe the connection manager. As a best practice, describe the connection manager in terms of its purpose, to make packages self-documenting and easier to maintain.
  • Path
    Type the complete path of the message queue. The format of the path depends on the type of queue.

    Queue type Sample path

    Public

    <computer name>\<queue name>

    Private

    <computer name>\Private$\<queue name>

    You can use "." to represent the local computer.

  • Test
    After configuring the MSMQ Connection Manager, confirm that the connection is viable by clicking Test.

Change History

Release History

17 July 2006

Changed content:
  • Added link to new topic about using remote private queues.
  • Provided syntax for queue paths.

See Also

Other Resources

Integration Services Error and Message Reference

Help and Information

Getting SQL Server 2005 Assistance