Using Data Migration Assistant to assess on-prem SSIS: Error

Tierney Jackson Smith 96 Reputation points
2021-11-12T14:31:18.687+00:00

I have DMA installed on a machine that also has Visual Studio 2019, Azure Feature Pack, and the third party components we use in our SSIS project, per the prerequisites listed on the Data Migration Assistant page. I want to connect to our SQL Server to analyze the on-prem SSIS for migration-stoppers and other potential issues. To be clear, only the ETL will migrate. Source and destination DBs remain on-prem for now and are not part of the assessment.

I’m connecting using Windows Authentication, and have verified that my account has the SQL Server permissions listed in the wizard. But when I connect and attempt to run the assessment on SSISDB, I get the error “The assessment of database ‘SSISDB’ on server [SERVERNAME] failed. The error message: ‘Value cannot be null. Parameter name: type’.”

DMA successfully connects to the server and the account being used has the appropriate permissions. What could the issue be?

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
547 questions
{count} votes

Accepted answer
  1. Tierney Jackson Smith 96 Reputation points
    2021-11-16T22:48:08.123+00:00

    Update for anyone else having this issue: I was told the Data Migration Assistant doesn't support assessment of SSIS running on SQL Server 2019. If this is the case, I hope Microsoft updates the documentation that implies that SQL Server 2019 is a valid source and destination across the board: https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.