Increase the performance of my SSIS package

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?
LVL 11
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

novaspoonmanConnect With a Mentor Commented:
Are you limiting the lookup query to only the columns you need?
Is there a clustered index on the PK?
Have you inspected the actual execution plan for your lookup query?
Reza RadConnect With a Mentor Commented:
Lookup is good,
just  you should be careful about choosing appropriate cache mode,
this is great article from SSIS team blog about lookup cache modes:

rajvjaAuthor Commented:
rajvjaAuthor Commented:

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

From novice to tech pro — start learning today.