Setup an IBM MQ Connection Manager

The IBM MQ Connection Manager is an SSIS connection manager component that can be used to establish connections with IBM MQ/WebSphere MQ. 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 the "Add SSIS Connection Manager" window. Select the "IBM MQ (KingswaySoft)" item to add a new IBM MQ Connection Manager.

New SSIS Connection

add SSIS IBM MQ connection manager

The IBM MQ Connection Manager contains 1 page of configuration.

  • General
  • Advanced Settings

General Page

The General page allows you to specify connection properties and login credentials to IBM MQ/WebSphere MQ.

SSIS IBM MQ connection manager

IBM MQ Settings
Queue Manager Name

The name of the queue manager that the component will connect to.

Remote Queue Manager

If the queue manager is not on the local machine, it can be accessed remotely. Only connections to queues in the same domain will work.

Host Name

The name of the remote machine.


The port number of the remote machine.

Channel Name

The channel on the local machine that will be used to connect to the remote machine. Defaults to the system channel SYSTEM.ADMIN.SVRCONN.

Authentication Mode:

The authentication mode to use. There are two authentication modes: credentials and certificate.

User ID

The user ID used to connect to the remote machine.


The password used to connect to the remote machine

Certificate Key Repository

The repository where the certificate is located, either the Current User repository or the Local Machine.

Certificate Label

The label of the certificate

SSL Cipher Spec

The SSL Cipher Spec of the selected certificate. A value can be selected for the list or typed in.

SSL Peer Name

The SSL peer name. Used to check the distinguished name of the certificate from the peer queue manager.

SSL Reset Count

The SSL reset count. When the limit is reached, IBM MQ disconnects from the queue manager and application are notified of that as an exception with MQRC_CONNECTION_BROKEN as the reason code

SSL Revocation Check

Determines if an SSL revocation check should be done

Use MQCSP Authentication

This option is only available when using the "Credentials" Authentication Mode. It can be used in order to enable MQCSP Authentication.

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 IBM MQ/WebSphere MQ.

Advanced Settings Page

The Advanced Settings page of the IBM MQ Connection Manager allows you to specify how you want to enable the Retry on Itermitent Errors option and configure additional properties.

SSIS IBM MQ connection manager - Advanced Settings

Optional Settings

This option allows you to enable the Retry on Itermitent Errors option.

Additional Properties

This option allows you to configure additional properties.