When you migrate your database workloads from SQL Server on premises to Azure database services, namely Azure SQL Database or Azure SQL Database managed instance, your ETL workloads on SQL Server Integration Services (SSIS) as one of the primary value-added services will need to be migrated as well. Azure-SSIS Integration Runtime (IR) in Azure Data Factory (ADF) supports running SSIS packages.
To establish a complete migration plan, a thorough assessment will help identify issues with the source SSIS packages that would prevent a successful migration.
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, identify compatibility issues and provides recommendations to help you address those issues.
To performance SSIS packages assessment using DMA, download and install the latest version of the tool from the Microsoft Download Center, and then perform the assessment.
Microsoft
