title: when to opt for caching in the Lookup component in SSIS
body: <p>In SSIS Look up there are 3 types of Caches..
  Full Partial  and No cache.</p>
  
  <p>In our solution it has always been used the default one(Full).Is there any particular scenarios,where it can go for Partial cache/No Cache?
  In our  solutions lockup tables are always small(example:-we have been looking at small tables to get the types or to get description).That might be the reason it has been configure in default(Full cache) mode?</p>
  
  <p>Please let me know the valuable suggestions and opinion.</p>