Sdílet prostřednictvím

  • Článek

MSMQ Connection Manager

An MSMQ connection manager enables a package to connect to a message queue that uses Message Queuing (also known as MSMQ). The Message Queue task that Microsoft SQL Server Integration Services includes uses an MSMQ connection manager.

When you add an MSMQ connection manager to a package, Integration Services creates a connection manager that will resolve to an MSMQ connection at run time, sets the connection manager properties, and adds the connection manager to the Connections collection on the package. The ConnectionManagerType property of the connection manager is set to MSMQ.

You can configure an MSMQ connection manager in the following ways:

  • Provide a connection string.

  • Provide the path of the message queue to connect to.

The format of the path depends on the type of queue, as shown in the following table.

Queue type

Sample path

Public

<computer name>\<queue name>

Private

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

You can use a period (.) to represent the local computer.

Configuring the MSMQ Connection Manager

You can set properties through SSIS Designer or programmatically.

For more information about the properties that you can set in SSIS Designer, see MSMQ Connection Manager Editor.

For information about configuring a connection manager programmatically, see ConnectionManager and Adding Connections Programmatically.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.