SQL Server 2017 Integration Services Cookbook

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 Convert to Project Connection, as shown in the following ...