Migrate on-premises SSIS workloads to SSIS in ADF

This article lists process and tools that can help migrate SQL Server Integration Services (SSIS) workloads to SSIS in ADF.

Migration overview highlights overall migration process of your ETL workloads from on-premises SSIS to SSIS in ADF.

The migration process consists of two phases: Assessment and Migration.

Assessment

Data Migration Assistant (DMA) is a freely downloadable tool for this purpose that can be installed and executed locally. DMA assessment project of type Integration Services can be created to assess SSIS packages in batches and identify compatibility issues.

Get Database Migration Assistant, and perform package assessment.

Migration

Depending on the storage types of source SSIS packages and the migration destination of database workloads, the steps to migrate SSIS packages and SQL Server Agent jobs that schedule SSIS package executions may vary. For more information, see this page.

Next steps

• Migrate SSIS packages to Azure SQL Managed Instance.
• Migrate SSIS jobs to Azure Data Factory (ADF) with SQL Server Management Studio (SSMS).