SSIS cache

5 pts.
Tags:
SSIS
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Gerzson
    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.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following