Back to the Future: Accelerating the Cloud Migration of Legacy SSIS with Azure Data Factory

This session focuses on the new features to unblock/accelerate cloud migration of legacy SSIS, such as 2008 or earlier versions, with Azure Data Factory (ADF).
We will first show you how to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – and extend it with custom/Open Source/3rd party components.
We will next show you how to enable the following scenarios: running SSIS packages stored in Azure Files as first-class activities in ADF pipelines, accessing Azure SQL DB/Managed Instance with OLEDB connectors that are configured for Azure Active Directory authentication with ADF managed identity, testing SSIS packages in ADF from SSDT, scheduling SSIS jobs in ADF from SQL Server Agent/3rd party orchestrators that invoke Azure-enabled dtexec.exe, etc.
We will finally show you the complete SSIS Migration Playbook to perform batch package assessments and batch package/job migrations using Data Migration Assistant/Service, dtutil.exe, scripts, etc.