lookup Transformation 1 Next Published February 5, 2012 at 1100 × 835 in In-depth Lookup Transformation SSIS (Full cache, Partial cache, No cache) modes