5

I'm trying to extract data from an Oracle DB to SQL Server with SSIS 2016.

I installed a Windows Server 2016, a SQL Server 2016 and a SSIS, a Visual Studio Professional 2017 and the ODTwithODAC122011 from Oracle for the drivers.

Searching for a solution I find this question: Error while extracting data from Oracle DB in SSIS

I try to set Run64bitRuntime as false but doesn't work for me and still get the following error:

The system cannot find message text for message number 0x80040e51 in the message file for OraOLEDB. (OraOLEDB)

In the following images I show the value for Run64bitRuntime variable and the error message.

Run64bitRuntime value

Error Message

Thanks for the help!

Amira Bedhiafi
  • 8,088
  • 6
  • 24
  • 60
jmclaps
  • 51
  • 5

0 Answers0