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
rajvjaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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?

http://www.ssistalk.com/2009/09/04/ssis-lookup-cache-modes-full-partial-none/
0
 
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:

http://blogs.msdn.com/b/mattm/archive/2008/10/18/lookup-cache-modes.aspx

0
 
rajvjaAuthor Commented:
t
0
 
rajvjaAuthor Commented:
Hi

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

From novice to tech pro — start learning today.