March 6, 2009 at 6:01 am
In a record I have multiple columns to validate for valid references.
For this do I need to have a lookup component for each column that needs to be validated?
What if I have around 10 lookup columns? Do I need to have 10 lookup transformation componets?
Please advice for the best solution.
Thanks
March 6, 2009 at 8:30 am
Assuming you cannot just have foreign keys on your destination table, using 10 lookups will be fine.
I have had packages with more than 30.
Remember that in full cache mode the lookups can eat up a great deal of memory and will populate their cache in the pre-execute phase.
Don't be afraid in SSIS to do a lot of sequential work like this. As an MSSQL DBA or Developer, it has been drilled into our heads that we want to do everything in set-based operations. SSIS is different - it is REALLY good at doing one thing and looping.
March 9, 2009 at 3:17 am
So you mean to say that adding n number of lookup components for each lookup column is fine?
Can you tell me if there would be any impact on the processing time and things like that...?
Will not the design look so big?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply