I encountered a scenario where a customer requested to move their existing SSIS packages from a 2008 R2 server to a 2016 SQL Server. This is not a typical request as it involves many considerations before migrating a package to a higher version. In this post, I will list the steps and considerations that I took before tackling this task of SSIS package migration.
Failed to execute IS server package because of error 0x80131904
Recently I faced an issue where SQL agent jobs executing SSIS packages were failing with error: “Failed to execute IS server package because of error 0x80131904. Description: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.” As per above error message it is evident that … Read more