How to fix SSIS (dtexec) System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException

Question

We have a very old SSIS package that runs fine on Windows Server 2012 R2. We are decommissioning the Windows Server 2012 R2 vm and have a Windows Server 2016 vm.

The SSIS package accesses Oracle. I can see within the script portion of the dtsx file:

using System.Data.OracleClient;

I think this System.Data.OracleClient is deprecated. We will address that later, but for now, we are just trying to get this dtsx to run successfully with the dtexe.exe on the Windows Server 2016 vm. We installed the SQL Server 2016 SSIS portion on the Windows Server 2016 vm.

We get:
Error
Code: 0xC0047062

Description: System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed...
Code: 0xC004701A

On the Windows Server 2012 R2 vm and on the new Windows Server 2016 vm, the 32-bit and 64-bit "ODBC Data Source Administrator" shows more-or-less the same Drivers installed. Just the Windows Server 2016 vm one has slightly updated ones.

Answer 1

Hi @brwillia,

This is caused by a mismatch between 32-bit version and 64-bit version component.

Please try to install both the 32 and 64 bit Oracle clients.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @brwillia,

I can see within the script portion of the dtsx file:

using System.Data.OracleClient;

It seems that your SSIS package is using a Script Task where it is accessing Oracle db. It is a reference to an assembly, and has nothing to do with Oracle ODBC drivers.

Check it out here: https://learn.microsoft.com/en-us/dotnet/api/system.data.oracleclient?view=windowsdesktop-7.0