Blog

Search results for: Lookup Transformation Task

SQL SERVER: SSIS - Look Up Transformation Task

13-Mar-2014

SQL SERVER: SSIS - Look Up Transformation Task

oday, I am going to give basic example of Lookup Transformation Task in SSIS.

Lookup transformation performs lookup operation by joining data in input columns with reference table dataset columns.Lookup can be used to access addition information from the reference dataset based on the matching criteria Reference dataset can be OLEDB table, Excel file or cache file, or SQL query result.