SSIS load from Oracle DB via MS Oracle source Attunity: Failed to load OCI method. OCIAttrSet
<p>I am trying to resolve an issue with unstable ETL process: Transformation of several tables from Oracle DB to MSSQL DB using Attunity source component.</p>

<p>The problem is that sometimes the SSIS package fails due to: <strong>Failed to load OCI method. OCIAttrSet</strong>. Rerun helps, but sometimes it is successful just after 10 reruns, sometimes it is successful after the first attempt. It seems to be very unpredictable and unstable which I do not like.</p>

<p>I was trying to set parameter <strong>DelayValidation = TRUE</strong> on the whole package and particular Data tasks, but it did not help.</p>

<p>One of my surmise is that the issue is caused by overloading the source DB and Oracle server is not able to send particular OCI methods.</p>

<p>Do you have any idea what it could be the problem and how to fix it? Thanks in advance!</p>

<p><strong>EDIT:</strong></p>

<p>I tried to use different OLE DB connection manager, especially <strong>Microsoft OLE DB Provider for Oracle</strong>.</p>

<p>I am currently having a new issue with collation. You can see below a preview of the data from Attunity connetion manager:
<a href="https://i.stack.imgur.com/qwPHs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qwPHs.png" alt="enter image description here"></a></p>

<p>And here is the samee dataset, but via Microsoft OLE DB Provider for Oracle.
<a href="https://i.stack.imgur.com/KWelT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KWelT.png" alt="enter image description here"></a></p>

<p>In both cases I am using code page 1250, any case of Microsoft OLE DB Provider for Oracle I have to set: "AlwaysUseDefaultCodePage" = True, nevertheless it does not solve the problem with special characters.</p>