During the upgrade process from SQL Server 2019 to 2022, everything is working fine except that the SSIS packages are failing to execute.
I attempted to upgrade and deploy the SSIS project, but the deployment failed. I then exported the existing project and tried to deploy them again, but no success.
I built the packages for all server versions and tried to deploy them one after another, but all attempts failed with same error 27203.
Detailed Error message
Pop up error
Similar issue but in Local system
Almost similar problem found, however the provided solutions are not useful. Server version is showing properly. No need to update the server name for my problem.
I tried error message using the below query, but no messages were found:
select * from operations_messages
I found the following error at Log File viewer in SSMS and the error as follows.
Message Application: ISServerExec.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.IO.FileNotFoundException at Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ISServerHelper.WriteEvent(Int32, System.Diagnostics.EventLogEntryType, System.Object[]) at Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ExecuteMain.Main(System.String[])
I'm looking for a solution to successfully deploy the SSIS project to SQL Server 2022.