Working on upgrading from SQL Server 2017 to SQL Server 2019. When using a desktop or another server running SQL Server 2017, SSMS v18.12.1 is used to import SSIS packages into MSDB on a remote server running SQL Server 2019, the SSIS package becomes corrupted. All "Analysis Services Processing Task" are replaced with DTS:ExecutableType="SSIS.ReplacementTask".
When I RDP to the SQL Server 2019 server and perform the Import into MSDB no Problem. A Desktop running SQL Server 2019 Developer edition with SSAS installed, has no problem Importing the SSIS Package into the remote MSDB on SQL Server v2019 server.
What changed with SQL Server 2019?
Results of working through some scenarios
DTUTIL v140 and v150 works on Importing and Exporting SSIS Package with SSAS Components. I saw no corruption. SQL Agent Job worked as expected.
SSMS v18.12.1 IMPORT of SSIS packages would give no error, but the SSIS package now has INVALID SSAS Component. SSMS v18.12.1 EXPORT of a working SSIS Package would replace the SSAS component with DTS:ExecutableType="SSIS.ReplacementTask".