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