Search results for: Lookup
2[1].png)
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.
