Perform a SQL Server Integration Service migration assessment with Data Migration Assistant

Prerequisites

To assess SQL Server Integration Service(SSIS) packages, below components need to be installed with Data Migration Assistant:

  • SQL Server Integration Service with the same version as the SSIS packages to assess.
  • Azure Feature Pack or other third party components if SSIS packages to assess have these components.

DMA needs to run with administrator access to assess SSIS packages in Package Store.

Performance assessments

The following step-by-step instructions help you perform your first assessment for migrating SQL Server Integration Service (SSIS) packages to Azure SQL Database or Azure SQL Database managed instance, by using Data Migration Assistant.

Create an assessment

  1. Select the New (+) icon, and then select the Assessment project type as Integration Service.

  2. Set the source and target server type.

    Select the source as SQL Server, and set the target server type as Azure SQL Database or Azure SQL Database managed instance.

  3. Click Create.

    create assessment

Connect to a server

  1. Follow the default option, and click Next towards Select sources.
  2. Enter the SQL server instance name, choose the Authentication type, set the correct connection properties.
  3. (Optional) Enter a folder path that contains SSIS packages.
  4. (Optional) Enter package encryption password if applicable.
  5. Click Connect to the source SQL server. Add source

Add sources to assess

  1. Select the SSIS package storage types to assess, and then select Add. Add source
  2. Select Add Sources to open the connection flyout menu, if need assess multiple folders.
  3. Click Start Assessment. Start assessment

View results

The Compatibility issues category provides partially supported or unsupported features that block migrating on-premises SSIS packages to Azure-SSIS Integration Runtime. It then provides recommendations to help you address those issues.

View results

Next steps