If we are dealing with a large amount of data, the lookup may be forced to do repetitive database queries creating a potential bottleneck. Now in SSIS 2008 there is a Caching Mode that defaults to ...