Montag, 25. Februar 2008

SSIS: chaching options versus network traffic

So, i'm still worrying about the different caching options (full, partial, none) of SSIS. With my current configuration (full caching), i am facing out of memory exceptions (at least sometimes, when things are going really bad).
But changing the settings to "partial" creates another problem: since SSIS and SQL are not running on the same machine, the new settings will increase network traffic (singleton queries).
Mh, i am really curious about which way to go. I will let you know when the time has come. Any kind of help is welcome :).

Mittwoch, 20. Februar 2008

Thougts on SSIS Lookups

Yesterday i came across SSIS out of memory exceptions that could possibly caused by lookups in my packages. I guess i will have to play around with the caching options of the lookup. Results will follow if i dont forget to post them :)