Migrating an SSIS package to Azure Data Factory

SQL SSIS is a widely used on-premises Extract, Transform, and Load (ETL) tool. In this recipe, we’ll learn how to migrate an existing SSIS package to Azure Data Factory.

We’ll do this by configuring an Azure SSIS IR, uploading the SSIS package to the Azure SQL Database SSISDB, and then executing the package using the Execute SSIS Package activity.

Getting ready

To get started, do the following:

1. Open a new PowerShell prompt. Execute the following command to log in to your Azure account from PowerShell:

     Connect-AzAccount

2. You will need an existing Data Factory account. If you don’t have one, create one by executing the following PowerShell script:

   $resourceGroupName = "PacktADE";
   $location = 'east us'
   $dataFactoryName = "ADFPacktADE2";
   $DataFactory = Set-AzDataFactoryV2 -ResourceGroupName $resourceGroupName -Location $location -Name $dataFactoryName

3. Download...