title: Performance issues of a data transfer between Oracle and SQL Server using SSIS
body: <p>I am trying to design a process that transfers data from Oracle to SQL Server 2016 by using SSIS. It is done with the aim of removing productive processes from an SQL Server 2000 instance, where the transfer had been realized with a Linked Server.</p>
  
  <p>The transfer I designed in SSIS process is slow.</p>
  
  <p>I tried using the "Native OLE DB\Microsoft OLE DB Provider for Oracle" as well as the "Native OLE DB\Microsoft OLE DB Provider for Oracle" OLEDB connection.</p>
  
  <p>The result is, that it takes about a minute to transfer 9,934 records of a data set that spans 28,228472 rows.</p>
  
  <p>I tried using the "Oracle Source" component with an "Oracle Connection Manager". </p>
  
  <p>The result is, I can test the connection, as well as design the process and even preview the result set. As soon as I run the package in my Visual Studio, it states the error: "The component metadata for could not be upgraded to the newer version of the component. The PerformUpgrade method failed."</p>
  
  <p>I need to be able to transfer the date in a reasonable amount of time.<br>
  The environment I am using is as follows:</p>
  
  <blockquote>
    <p>Visual Studio: Visual Studio 2019 16.2.0<br>
    SSIS project compatibility mode is: SQL Server 2016<br><br>
    Targeted SQL Server: SQL Server 2016 (13.0.5233.0)<br>
    The SSIS package will be run on: SQL Server 2016 (13.0.5264.1)<br><br>
    The Oracle environment is: <br>
    Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production </p>
  </blockquote>