These days databases are being migrated from an On-Premise SQL Server to Azure database services like Azure SQL Database, Azure SQL Data warehouse, etc. So, SSIS will also need to be migrated to Azure cloud service. For this Microsoft provides a cloud version of integration service known as Azure Data Factory (ADF).
ADF is benefitted in below scenarios:
If an organization has decided to migrate its database from On-premise to Azure database services and wants to use existing ETL and data integration workflow then SSIS solution can also be migrated to Azure in its cloud-based integration services ADF V2.
Microsoft's recent release of ADF V2 provides Azure-SSIS Integration Runtime to allow the execution of on-premise SSIS projects on Azure’s Cloud resources. While configuring this integration runtime SSIS catalog can be set up with any one of these database flavors.
After Setting up SSIS Integration Runtime, SSIS solution can be deployed in integration services catalog in the following ways:
ADF provides different activities to run the various computation services. “Execute SSIS package” activity is used to run the SSIS packages in the ADF pipeline. In this Activity, two settings are required:
Fig: Diagram of SSIS Package in Azure
Migrated SSIS packages in Azure can be scheduled using Trigger and monitored with the below tools: