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 :).
Posts mit dem Label SSIS Lookup Memory werden angezeigt. Alle Posts anzeigen
Posts mit dem Label SSIS Lookup Memory werden angezeigt. Alle Posts anzeigen
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
Kommentare (Atom)