Using the Azure Blob Storage Connection Manager

The Azure Blob Storage Connection Manager is an SSIS connection manager that can be used to establish connections with Azure Blob Storage.

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

New SSIS Connection

Add SSIS Azure Blob Storage Connection

The Azure Blob Storage Connection Manager contains the following 3 pages of configuration.

  • General
  • Advanced Settings
  • More Info

General page

The General page allows you to specify connection properties and login credentials to Azure Blob Storage.

SSIS Azure Blob Storage Connection

Use Azure Storage Emulator

Check the Use Azure Storage Emulator option allows you to use the Azure storage emulator to run and test your package in a local environment without creating an Azure subscription. When you are satisfied with how your SSIS package is working with the emulator, you can switch to using an Azure storage account in the cloud.

Storage Endpoints Domain

The Storage Endpoints Domain drop-down displays a list of domain which allows you to pick the endpoint based on your location. There are five options available:

  • Azure
  • Azure China
  • Azure Germany
  • US Government
  • Other (enter below)
Use HTTP (Not recommended)

Check the Use HTTP option to force to use HTTP to interact with Azure Blob Storage. The Azure Storage Services support both HTTP and HTTPS; however, using HTTPS is highly recommended.

Account Name

The Account Name option allows you to specify the Storage Account you've created in Azure Storage Services.

Access Key

The Access Key option allows you to specify the access key for the Azure storage account.

Upload Chunk Size (in MB)

The Upload Chunk Size option allows you to specify the size of the block when you create block blobs or append blobs.

Timeout (secs)

The Connection Timeout option allows you to specify the number of seconds for the request timeout values. The default value is 120 seconds.

Retry on Intermittent Errors

Use this option to indicate if Azure Blob Storage retry policy will be used. The Azure Storage SDK built-in retry policy provides support for linear (constant delay) and exponential with randomization retry intervals. Uncheck this option to effectively disables retries.

Advanced Settings

The Advanced Settings page of Azure Blob Storage Connection Manager allows you to specify how you want to configure the proxy server.

SSIS Azure Blob Storage Connection - Advanced Settings

Proxy Mode

Proxy Mode option allows to specify how you want to configure the proxy server setting. There are three options available.

  • No Proxy
  • Auto-detect (Using system configured proxy)
  • Manual
Proxy Server

Using the Proxy Server option, you can provide a proxy server to connect to Azure Blob Storage.

Port

The Port option allows you to specify port number of the proxy server for the connection.

Username

The Username option allows you to specify the proxy user account.

Password

The Password option allows you to specify the proxy user’s password.

Note: Proxy Password is not included in the Azure Blob Storage connection manager’s ConnectionString property by default. This is done by design for security reasons. However you can include it in your ConnectionString if you want to parameterize your connection manager. The format would be ProxyPassword=myProxyPassword; (make sure you have a semicolon as the last character). It can be anywhere in the ConnectionString.

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.

SSIS Azure Blob Storage Connection - More Info