title: Error while extracting data from Oracle DB in SSIS
body: <p>I have been trying to connect to Oracle DB (11g) in SSIS (VS2015) from past few days and tried all possible solutions but still getting error. I am passing query through SSIS variable, no other parameter is passed, it is just test query which need to retrieve two rows.</p>
  
  <p><strong>Case 1:</strong> Tried using <strong>Oracle Provider for OLEDB</strong>, test connection is successful but getting below error while Preview data:</p>
  
  <blockquote>
    <p>The system cannot find message text for message number 0x80040e51 in the message file for OraOLEDB. (OraOLEDB)</p>
  </blockquote>
  
  <p><strong>Case 2:</strong> Tried using <strong>Microsoft OLEDB Provider for Oracle</strong>,  test connection is successful but getting below error while Preview data:</p>
  
  <blockquote>
    <p>Provider cannot derive parameter information and SetParameterInfo has not been called.</p>
  </blockquote>
  
  <p>I have been struggling to solve this problem, any help would be appreciated. Thanks in Advance.</p>
  
  <p>Edit: After setting Run64bitRuntime to false, I can extract data when using Oracle Provider for OLEDB, but Preview still gives same error.</p>
  
  <p>Regards,</p>
  
  <p>Jazz</p>