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. If not open, open the package we're using from the previous recipe: ETL_Staging.StgAggregatedSales.dtsx.
  2. Right-click on the Connection Manager pane, add New Connection..., and select AzureResourceManager. Fill out the properties following the instructions provided at the following link: https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-create-service-principal-portal.
  1. Your connection manager should look like the one in the following screenshot:
  1. Drag and drop an Azure Create Cluster task from the SSIS toolbox on the control flow and attach it to the felc_HDP_Export Foreach Loop container. Rename ...

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