Data Migration Assistant (DMA) is released to provide migration assessment of SSIS packages

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.


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.

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.