ISServerExec.exe crash when executing from SQL schedule job

Question

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

Answer 1

Thanks, we found the solution.

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