title: Why does my SSIS package not pull all the data from a specific table in Oracle?
body: <p><strong>Situation</strong>: I have created an SSIS package that has a OLE DB Source that is an Oracle Database and an OLE DB destination of SQL Server. I use [Oracle Provider for OLE DB] connection. </p>
  
  <p><strong>Problem</strong>: when I execute the package it will run short and only return 220,000 out of 4 million records. The package runs with no errors and no warnings. Just successfully completes but will not go past 220,000 records. I found one similar problem on this site however it pointed to a date format issue and this table has no date data types in its structure. </p>
  
  <p>Troubleshooting so far:</p>
  
  <ol>
  <li><p>I extracted the table as a flat file and ran the package to the same destination table, this runs fine. All 4 million records will load from flat file to destination ok.</p></li>
  <li><p>I have tried running the package as a fast load and a normal - no change</p></li>
  <li><p>I have tried different buffer combinations and Auto Adjust Buffer Size - no change</p></li>
  <li><p>I have uninstalled and reinstalled, VS, Oracle 12c, SSDT - No change</p></li>
  <li><p>I thought maybe it could be memory or size issue, no luck, I load many other tables that are larger in size memory wise. </p></li>
  </ol>
  
  <p>Environment Specs: </p>
  
  <ul>
  <li>VS V 15.9.14</li>
  <li>Oracle Developer Tools for Visual Studio 12.2.0.1.0</li>
  <li>SSDT 15.1.61906.3120</li>
  <li>SSIS 15.0.1301.433</li>
  <li>SQL Server 2016 13.0.4 - SP1</li>
  </ul>
  
  <p>Has anyone dealt with something like this what are somethings I could try or look into?</p>
  
  <p>Thanks!</p>