LookUp Full cache vs Cache Transform ?


  • Team ,

    Greetings !

    Do we have any difference between using LookUp Full Cache mode vs CacheTransform ( Cached connection Manager ) ?

    Thanks in advance !

    Rajkumar Yelugu

    • Changed type Rajkumar Yelugu Monday, October 07, 2013 5:33 AM This is a Question
    Sunday, October 06, 2013 6:35 PM


  • You can use other sources like a Flat File in the Cached Connection Manager. Otherwise you first have to stage it into a table before you can use it in a lookup.

    Please mark the post as answered if it answers your question | My SSIS Blog: | Twitter

    Monday, October 07, 2013 5:41 AM

All replies