Azure Blob storage data management

This recipe will cover the following topics:

• Creating a Blob storage in Azure
• Using SSIS to connect to a Blob storage in Azure
• Using SSIS to upload and download files
• Using SSIS to loop through the file using a for each loop task

Getting ready

This recipe assumes that you have a Microsoft Azure account. You can always create a trial account by registering at https://azure.microsoft.com .

How to do it...

1. In the Azure portal, create a new storage account and name it ssiscookbook.
2. Add a new package in the ETL.Staging project and call it AggregatedSalesFromCloudDW.
3. Right-click in the Connection Manager pane and select New file connection from the contextual menu that appears.
4. The Add SSIS Connection Manager window appears. Select Azure Srorage and click on the Add... button.

5. Fill the Storage account name textbox, as shown the following screenshot:

6. Rename the connection manager cmgr_AzureStorage_ssiscookbook.
7. Right-click on the newly created connection manager and select...