The SSIS Lookup Transformation

By Sunday, October 7, 2012 Permalink 3

The SSIS Lookup Transformation is a classic SSIS component where the values of  common columns between an input and a reference dataset are compared to extract additional columns of interest; that is, the objective is to add data from one dataset to other. Overall, a lookup transformation requires three elements: an input dataset, a reference ...