ISServerExec.exe crash when executing from SQL schedule job

1

I have ETL packages that works fine in Visual Studio 2019

When we deploy and run it from SQL Server Agent, it gives the error below

Additional info: the package is set to "Encrypt sensitive with password" and we set the connection password in the SQL Job step settings

Faulting application name: ISServerExec.exe, version: 14.0.1000.169, time stamp: 0x599ccc42

Faulting module name: **OraOLEDB11.DLL, version: 11.2.0.1, time stamp: 0x4b9a19db

Exception code: 0xc0000005

Fault offset: 0x000000000002c000

Faulting process id: 0x3954

Faulting application start time: 0x01d642753af07699

Faulting application path: c:\Program Files\Microsoft SQL Server\140\DTS\Binn\ISServerExec.exe

Faulting module path: C:\oracle\oracleclient64\bin\OraOLEDB11.DLL

Report Id: 0db0c583-e4aa-4dec-89f5-509f3969595c

Faulting package full name:

Faulting package-relative application ID:


UPDATE Tried executing package from Integration Services Catalog in SSMS but also failed, the detailed error is "cannot acquire connection from connection manager" It looks something related to password in the oracle database connection

sql
ssis
sql-server-agent
sql-server-job
asked on Stack Overflow Jun 14, 2020 by Mohamed ElSheikh • edited Jun 15, 2020 by Mohamed ElSheikh

1 Answer

0

Thanks, we found the solution.

It works when we changed the runtime in SQL Server Job Step properties to 32-bit

answered on Stack Overflow Jun 16, 2020 by Mohamed ElSheikh

User contributions licensed under CC BY-SA 3.0