Setup an Azure Service Bus Connection Manager

The Azure Service Bus Connection Manager is an SSIS connection manager component that can be used to establish connections with Azure Service Bus. 

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 "Azure Service Bus (KingswaySoft)" item to add a new Azure Service Bus Connection Manager.

New SSIS Connection

Add SSIS Azure Connection

The Azure Service Bus Connection Manager contains 1 page of configuration. 

  • General

General page

The General page allows you to specify connection properties and login credentials to Azure Service Bus. 

Add SSIS Azure Connection Manager

Namespace:

The namespace field lets you specify the URL of your Azure Service Bus endpoint. It should follow the pattern of: example.servicebus.windows.net/

Issuer Name

The issuer name that will be used for authentication.

Issuer Key

The issuer key that will be used for authentication.

Enter Connection String Button

Add SSIS Azure Connection Manager - string

If you have a connection string, you can click the 'Enter Connection String' button to enter it. The component will extract the relevant parts of the connection string to populate other fields in the connection manager.

Transport Type

The transport type you would like to use with your connection.

Operation Timeout

The timeout value for operations with your connection.

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 Azure Service Bus.

More Info

The More Info page shows some basic information about the toolkit. In this page, you can find the version information of the toolkit.

Add SSIS Azure Connection Manager - more info