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