O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

 

 

  1. Fill the Storage account name textbox, as shown the following screenshot:
  1. Rename the connection manager cmgr_AzureStorage_ssiscookbook.
  2. Right-click on the newly created connection manager and select Convert to Project Connection, as shown in the following ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required