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 ...

Get SQL Server 2017 Integration Services Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.