OLE DB Dest error for Oracle table with Fast Load option
<p>I got a simple DataFlowTask which pulls data from Netezza source and loads to Oracle Table through OLE DB Source/Destination components. The loads works well with Dest - Table or View drop down selecting the table to load and mapping columns.</p>

<p>However, this option is very slow since it performs record by record and commits transaction after each record insert. And since Table or View Fast Load option works at batch level and much faster, I wanted to configure this option and select the table from the drop down.</p>

<p>After the table is selected and click on Column Mappings tab, Error being generated </p>

<p>Note :</p>

<ol>
<li>Load works very well for just Table or View option</li>
<li>Ensured, the OraOLEDB provider and its configured correctly in the registry</li>
<li>No issues on the datatypes- all maps correctly</li>
<li>Connection string is correctly pointing to Oracle Target DB and also cross checked for PersistSecurityInfo property : TRUE / FALSE no effect</li>
<li>Provider=OraOLEDB.Oracle.1; correctly referring to the one configured in registry</li>
</ol>

<p>Only problem, Fast Load option is not working. 
version : SSIS 2012 / Oracle 11g / 32-bit package configuration on a 64-bit Windows machine.</p>

<p><a href="https://i.stack.imgur.com/8cKG8.png" rel="nofollow"><img src="https://i.stack.imgur.com/8cKG8.png" alt="enter image description here"></a></p>