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.

Hi Friends,, May i know how much cache memory storage in ssis2008 version

Can you be a bit more specific? Your question isn't exactly clear.MCTS, MCITP - Please mark posts as answered where appropriate.

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

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.