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 :).
Montag, 25. Februar 2008
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 :)
Abonnieren
Posts (Atom)