Blast to The Future: Accelerating Legacy SSIS Migrations into Azure Data Factory
This session focuses on the new features to unblock/accelerate cloud migration of legacy SSIS with Azure Data Factory (ADF). We will first show you how to provision Azure-SSIS Integration Runtime (SSIS IR) dedicated ADF servers for running SSIS and extend it with custom/Open Source/3rd party components via standard/express custom setups. We will next show you how to enable the following scenarios: assessing SSIS packages for cloud compatibility and testing their executions in ADF from SSDT, accessing data on premises by joining SSIS IR to a VNet or using Self-Hosted IR as a proxy for SSIS IR, accessing Azure SQL DB/Managed Instance with OLEDB connectors that are configured for Azure Active Directory authentication with ADF managed identity, running SSIS packages stored in MSDB/SSISDB/file system/Azure Files/SSIS IR package stores or embedded in ADF JSON payload as first-class activities in ADF pipelines, scheduling SSIS jobs in ADF from SQL Server Agent/3rd party orchestrators that invoke Azure-enabled dtexec.exe, monitoring and alerting on SSIS IR operations and SSIS package executions using Azure Monitor, etc. We will finally show you the complete SSIS Migration Playbook to perform package assessments and package/job migrations using SSDT, Data Migration Assistant, Database Migration Service, dtutil.exe, scripts, etc.