最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

Not able to deploy the SSIS package after upgrading SQL Server 2019 to SQL Server 2022 - Stack Overflow

programmeradmin3浏览0评论

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.

发布评论

评论列表(0)

  1. 暂无评论