I share with you a problem I had recently on SSIS.
Problem Description: When you start treatments in parallel, your SSIS packages fail error. You have two servers and one reproduces this behavior.
You got the following error: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Cause: We initially verified that the versions of drivers were exactly the same on both servers.
- The server with the issue was in DataAccess64 Sybase build 15.05.00.9000
- The server without the issue was in DataAccess64 Sybase build 15.05.00.1015
Resolution: We have copied only directories DataAccesset DataAccess64 Sybase client (build 15.05.00.1015) to the client installed (build 15.05.00.9000).
The problem has been fixed with this workaround.
If you can not fix your problem I invite you to generate a dump, then call MS support.
Michel Degremont | Premier Field Engineer – SQL Server Core Engineer |