Lookup
I'm not sure there is an upper limit for the cache size in 2008.
This blog post explains how to calculate the cache size:
http://blogs.msdn.com/b/mattm/archive/2008/10/18/calculating-the-size-of-your-lookup-cache.aspxMCTS, MCITP - Please mark posts as answered where appropriate.
August 2nd, 2012 7:40am
Hi Friends,,
May i know how much cache memory storage in ssis2008 version
Free Windows Admin Tool Kit Click here and download it now
August 4th, 2012 6:52am
Can you be a bit more specific? Your question isn't exactly clear.MCTS, MCITP - Please mark posts as answered where appropriate.
August 4th, 2012 7:24am
ok
in ssis2005 under lookup u can give cache size upto 3072mb size
in ssis2008 under lookup how much size for cache size ? means any fixed size is there or depending on data we can put cache size
Free Windows Admin Tool Kit Click here and download it now
August 4th, 2012 8:02am
I'm not sure there is an upper limit for the cache size in 2008.
This blog post explains how to calculate the cache size:
http://blogs.msdn.com/b/mattm/archive/2008/10/18/calculating-the-size-of-your-lookup-cache.aspxMCTS, MCITP - Please mark posts as answered where appropriate.
August 4th, 2012 8:12am