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
Using Data Migration Assistant to assess on-prem SSIS: Error
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?