Migrating SSIS packages to Azure – Lift and Shift using Azure Data Factory

Unlike an on premises SQL Server, Integration Services (SSIS) works very differently on Azure. If there are requirements to run our existing SSIS packages on Azure, then we need to understand our options. In this article we will talk about our options for migrating SSIS to Azure and what components are required to migrate SSIS packages.

Options to Migrate SSIS to Azure

When we talk about migrating SSIS packages to Azure, there are two options:

Migrate SSIS to IaaS Migrate SSIS to PaaS 

Each of these is discussed below.

Migrating SSIS to IaaS

SSIS to IaaS works same as it works