<div>
Hi <br />
<br />
Sorry mates. I clicked Accept Multiple solutions and submit, its sending Close request. Why I am not sure.
</div>


Hi

Sorry mates. I clicked Accept Multiple solutions and submit, its sending Close request. Why I am not sure.

<div>
<div class="content wysiwyg-content">
Hi experts,<br />
&nbsp; &nbsp;I am retrieving data from Oracle and importing to sql server. There are 1 million records in the source.<br />
After getting from the source, I need to LookUp in the existing table whether the PK ID exists or not. For this, I am using LookUp transform in full cache mode. But it is slow.<br />
<br />
What is the best way to increase the performance instead of Lookup?
</div>
</div>


Hi experts,
   I am retrieving data from Oracle and importing to sql server. There are 1 million records in the source.
After getting from the source, I need to LookUp in the existing table whether the PK ID exists or not. For this, I am using LookUp transform in full cache mode. But it is slow.

What is the best way to increase the performance instead of Lookup?

Increase the performance of my SSIS package

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.