Home > IT Answers > Big Data > SSIS cache
Kurt
5 pts.
 SSIS cache
SSIS, SSIS 9.00.3042.00, SSIS Lookup Cache
We are developing packages in a SSIS environment using Version 9.00.3042.00. I’m presently having problems or a misunderstanding on when to use Partial or Full cache on lookups. Seems like the lookup results differ when using these two modes. For example, full lookups often “succeed” (turn green) but result in no matches while changing the same lookup to use partial or no cache will result in data matching but much slower performance. This has been observed on tables of varying sizes, but is most common on large (hundreds of thousands of rows) tables. I would like to know if anyone is experiencing similar issues and if possible to offer some explanation and possible workaround or corrective measures. I would also be interested in knowing if there any other methods to speed up lookup performance. Would like to find out what the best practice for writing SSIS lookups. Any help is much appreciated.

Software/Hardware used:
ASKED: February 12, 2009  1:06 PM
UPDATED: May 5, 2011  2:56 PM
RELATED QUESTIONS
Answer Wiki:
Maybe there are more records than will fit in cache, so using full cache you are not comparing to the complete file. Also, if any records are changed during runtime, the changed records will not be in cache.
Last Wiki Answer Submitted:  September 16, 2009  12:02 am  by  Qbjgqbjg   40 pts.
All Answer Wiki Contributors:  Qbjgqbjg   40 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi, I experienced the same problem with SSIS 2008. I have fixed the problem with turning off cacheing, which of course caused performance loss. I could never find the exact cause of the cache bug.

Gerzson
 10 pts.