SSIS Oracle 32 bit error "Invalid access to memory location."

2

My SSIS extracts data from Oracle DB and loads into the excel file. I am running this package via SQL Job. Now to use Excel providers I have to use 32 bit environment. So I've changed the SQL JOB execution to "Use 32bit runtime".

But now my oracle task is failing with error "Invalid access to memory location."

When I don't use 32bit runtime in job, the oracle task works but the excel task fails.

We have both 32bit and 64bit Oracle installed on the server. So not sure why oracle task is failing in 32bit environment.

Any help will be appreciated. Thanks in advance.

Detailed error message..

Error code: 0x800703E6. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x800703E6 Description: "Invalid access to memory location.". End Error Error: 2017-05-09 08:45:31.48 Code: 0xC00291EC Description: Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:45:30 AM Finished: 8:45:31 AM Elapsed: 1.435 seconds. The package execution failed. The step failed.

sql-server
excel
oracle
ssis
32bit-64bit
asked on Stack Overflow May 9, 2017 by Nakul Varge

1 Answer

-1

I always use TOAD "export to excel" [no coding] option

answered on Stack Overflow May 10, 2017 by Roger Cornejo

User contributions licensed under CC BY-SA 3.0