MSMQ Connection Manager

The MSMQ Connection Manager is an SSIS connection manager component that can be used to establish connections with Microsoft Message Queue.

To add a new connection, right-click the Connection Manager area in your Visual Studio project, and choose "New Connection..." from the context menu. You will be prompted with the "Add SSIS Connection Manager" window. Select the "MSMQ (KingswaySoft)" item to add a new MSMQ Connection Manager.

New SSIS Connection

add MSMQ Connection Manager

The MSMQ Connection Manager contains one page of configuration:

  • General

General page

The General page allows you to specify the queue path and connection properties to MSMQ.

SSIS MSMQ Connection Manager

Queue Path

The queue path field lets you enter the path of the queue you would like to connect to.

Browse Button

SSIS MSMQ Connection Manager - Select Queue

If you do not know the path of your queue you can click the browse button launch the Select Queue dialog and help locate it. By default, the Select Queue dialog will list any Microsoft Message Queues that are located on the local machine. The Server Name dropdown will list other servers that are visible to your local machine, and selecting a server will list any Microsoft Message Queues that it contains. If the server you want is not listed you can type the name, and type search to list any message queues on that server.

If you would like to create a new queue on the selected machine, click the 'Create Queue' button.

Create Queue Button

SSIS MSMQ Connection Manager - Create Queue

Clicking the 'Create Queue' in the 'Select Queue' dialog will open a dialog that allows queues to be created. In the create queue dialog enter the name of the queue you wish to create and whether it is a public or private queue. After you click OK the queue will be created and selected in the 'Select Queue' or if queue creation failed an error message will be shown.

Test Connection

After all the connection information has been provided, you may click the "Test Connection" button to test if the user credentials entered can connect to MSMQ.