Did any one get any solution for this. I am also trying to migrate the SSISDB/Catalog from SQL2016 to SQL2019 and getting same error. Its seems like it is the MS bug for SSIS migration with upgrading SSIS version. I can migrate successfully between same version of SQL server but not like with upgrade new version. I follow the exact stapes which MS provided in their link with freshly setup the sql server, I can successfully setup in SQL2016(same version) but not to SQL2019
If anyone know how to migrate the SSISDB/Catlaog to high version please let us know. I have more then 4oo SSIS projects and around 900 siss packages are there, I can't manually import one by one.
msg 27222, Level 16, State 1, Line 49
The required components for the 64-bit edition of Integration Services cannot be found. Run SQL Server Setup to install the required components.
Msg 6522, Level 16, State 1, Procedure internal.check_schema_version_internal, Line 0 [Batch Start Line 48]
A .NET Framework error occurred during execution of user-defined routine or aggregate "check_schema_version_internal":
System.Data.SqlClient.SqlException: The required components for the 64-bit edition of Integration Services cannot be found. Run SQL Server Setup to install the required components.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteToPipe(SmiContext pipeContext)
at Microsoft.SqlServer.Server.SqlPipe.ExecuteAndSend(SqlCommand command)