we will migrate from SQL Server 2008 R2 to SQL Server 2019 in near future, we already run DMA to analyze database, however DMA 5.2 doesn't support migration assessment type for intergration services (SSIS) when the destination server is a local SQL Server, only supports Azure SQL Database ou Azure SQL Managed Instance,
As stated in "assessment for migrating SQL Server Integration Service (SSIS) packages to Azure SQL Database or Azure SQL Managed Instance, by using Data Migration Assistant." from https://docs.microsoft.com/en-us/sql/dma/dma-assess-ssis?view=sql-server-ver15
Any alternative to evaluate SSIS code compatiblity with new version?
Only option i could find was executing DTexec with Validate parameter (and i don't know if is even similar to DMA):
/Va[lidate]: (Optional). Stops the execution of the package after the validatation phase, without actually running the package. During validation, use of the /WarnAsError option causes dtexec to treat a warning as an error; therefore the package fails if a warning occurs during validation.
Best Regards, Carlos