Azure Storage Connection Manager
 PreviousNext

Azure Storage Connection Manager can be used to connect to Azure Storage Services such as Azure Blobs and Azure Table Storage.

Download SSIS PowerPack

Content

Video Tutorial

Step-By-Step

In this tutorial you will learn how to create Azure Storage Connection. You can create multiple connection(In this case its Windows Azure Storage Emulator and Online Storage Account).

How to create Azure Storage Connection with Windows Azure Storage Emulator.

  1. Firstly, You need following Prerequisite.
  2. Once you finished above steps, Open Visual Studio and Create New SSIS Package Project.
  3. Right click in the Connection Manager panel and click on New Connection.
    SSIS Create New Connection
  4. Select ZS-AZURE-STORAGE Connection Manager from the Connection Managers list and Click on Add Button.
    SSIS Azure Storage Connection - Add
  5. In the connection manager UI, Select use the Microsoft Azure storage Emulator.
    Azure Storage Connection Manager UI - Windows Azure Storage Emulator
  6. Click on Test Connection to check configure correct or not.
  7. Click on OK to save Azure Storage Connection manager setting UI.
  8. Once you finished, you will see Microsoft Azure Blob Storage connection in Connection Manager panel.
    Azure Storage Connection Manager UI - Success

How to create Azure Storage Connection with Online storage account.

  1. Firstly, you need to obtained credentials of Azure Storage Account.
  2. Once you finished above steps, Open Visual Studio and Create New SSIS Package Project.
  3. Right click in the Connection Manager panel and click on New Connection.
    SSIS Create New Connection
  4. Select ZS-AZURE-STORAGE Connection Manager from the Connection Managers list and Click on Add Button.
    SSIS Azure Storage Connection - Add
  5. In the connection manager UI, Select enter storage account credentials and enter it.
    Azure Storage Connection Manager UI - Online Account
  6. Click on Test Connection to check configure correct or not.
  7. Click on OK to save Azure Storage Connection manager setting UI.
  8. Once you finished, you will see Microsoft Azure Blob Storage connection in Connection Manager panel.
    Azure Storage Connection Manager UI - Success

Properties

Property Name Description
UseProxy Enable custom proxy settings (If this is not set then system default proxy will be used. To disable proxy totally uncheck this option and check DoNotUseDefaultProxy option if available)
ProxyUrl Web URL of Proxy server (including port  if necessary). [e.g. http://myproxyserver:8080/]
DoNotUseDefaultProxy Do not use system default proxy (This setting is ignored if UseProxy=true)
ProxyUseCreds Enable passing userid and password to proxy server
ProxyPassword Proxy password
ProxyUserName Proxy username
AccountName
CustomBlobEndPoint
CustomTableEndPoint
CustomQueueEndPoint
AccountKey
SharedAccessSignature SAS URL or Token
UseDevelopmentStorage
ConnectionString
ProgressUpdateInterval Update interval in KB. System will report upload/download progress based on this setting. By default progress is reported every 1000 KB.
Timeout
MaxRetryOnError
RetryInterval
MaxParallelThreads

Setting UI

Azure Storage Connection Manager UI - Setting UI
Azure Storage Connection Manager UI - Setting UI

See Also

References

Copyrights reserved. ZappySys LLC.