title: SSIS DTS_E_OLEDBERROR and Out of Memory Error transferring SQL Server records to Oracle Database
body: <p>I'm trying to import around 5M records from a SQL Server database to an Oracle Database and am getting an <code>Out of Memory</code> error.  See details below. I've tried a number of recommendations already from researching, but haven't found a solution.</p>
  
  <p>Things I've tried/Notes:</p>
  
  <ol>
  <li>Source is SQL Server using "OLE DB Source" and the "SQL Server Native Client 11.0" Driver</li>
  <li>Destination is Oracle Db using "OLE DB Destination" and the "Oracle Provider for OLE DB" driver. </li>
  <li>I tried the "Microsoft OLE DB Provider for Oracle" as the destination instead.</li>
  <li>I tried increasing the "Defalut Buffer Size" the Data Flow to 100 MB </li>
  <li>I tried increasing the "DefaultBufferMaxRows" to 10 M rows.</li>
  <li>The computer is 64-bit with 16GB of RAM and has Windows 7 Professional.</li>
  <li>I have both the 32-bit and 64-bit Oracle Client installed</li>
  <li>The SSIS project's "Run64bitRuntime" property is set to True.</li>
  <li>I'm using Visual Studio 2015.</li>
  </ol>
  
  <p>Any ideas?</p>
  
  <p>Here are the pertinent messages.</p>
  
  <blockquote>
    <p>Warning: 0x80047076 at Data Flow Task Load PFILSA OneLink Table 
        2012, SSIS.Pipeline: The output column "DateTime" (137) on output 
        "OLE DB Source Output" (105) and component "OLE DB Source" (94) is 
        not subsequently used in the Data Flow task. Removing this unused 
        output column can increase Data Flow task performance.</p>
    
    <p>Error: 0xC0202009 at Data Flow Task Load PFILSA OneLink Table 2012, 
        OLE DB Destination [12]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE 
        DB error has occurred. Error code: 0x8007000E.</p>
    
    <p>An OLE DB record is available.  Source: "Microsoft Cursor Engine"<br>
        Hresult: 0x8007000E  Description: "Out of memory.".</p>
  </blockquote>