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...
- In the Azure portal, create a new storage account and name it
ssiscookbook. - Add a new package in the
ETL.Stagingproject and call itAggregatedSalesFromCloudDW. - Right-click in the
Connection Managerpane and selectNew file connectionfrom the contextual menu that appears. - The
Add SSIS Connection Managerwindow appears. SelectAzure Srorageand click on theAdd...button.
- Fill the
Storage account nametextbox, as shown the following screenshot:
- Rename the connection manager
cmgr_AzureStorage_ssiscookbook. - Right-click on the newly created connection manager and select...
