Understanding SSIS packages migration to Azure Data Factory

Introduction

Integration Runtime Scenarios

Pre-requisites

  1. Azure Data Factory resource in Azure (ADF)
  2. SQL Managed Instance in Azure (SQL MI)
  3. Visual Studio 2019 (VS)
  4. Visual Studio Data Tools (SSDT)

Setup SSIS Integration Runtime in Azure Data Factory

  1. Name: Name of integration runtime.
  2. Location: Specify the location where integration runtime is created.
  3. Node size: The node size is the size and power of the virtual machine(s) that are running your integration runtime. if you are planning to run many packages in parallel, it is recommended to select high performing tier for that VM. Click Configure performance for the Azure-SSIS Integration Runtime — Azure Data Factory | Microsoft Docs to find out more about configuring SSIS-IR for high performance.
  4. Node Number: adjusts the scalability of the integration runtime. The throughput of the integration runtime is proportional to the AzureSSISNodeNumber. Set the AzureSSISNodeNumber to a small value at first, monitor the throughput of the integration runtime, then adjust the value for your scenario.
  5. Edition/license: Select appropriate license as per your environment and needs. You can also take advantage of Azure Hybrid Benefits for SQL Server in licensing.
  6. Click Continue

Package Development in Visual Studio

Create a project in Visual Studio

Package Design

Deploy the package

Verify Package

Run SSIS Package in ADF

Conclusion

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Afzal Muhammad

Afzal Muhammad

Innovative and transformative cross domain cloud solution architect @Microsoft (& xCisco). Helping companies to digitally transform!!!