Lookup Transformation Editor (Columns Tab)
Use the Columns tab of the Lookup Transformation Editor dialog box to specify the join between the source table and the reference table, and to select lookup columns from the reference table.
To learn more about the Lookup transformation, see Lookup Transformation.
- Available Input Columns
Drag input columns to connect them to available lookup columns. The input columns are the columns in the data flow from the source table, while the lookup columns are the columns in the reference table in which you want to look up matching values. The input columns and lookup column must have matching, data types. Select a mapping line and right-click to edit the mappings in the Create Relationships dialog box.
- Available Lookup Columns
Use the check boxes to select columns on which to perform lookup operations.
- Lookup Column
Select lookup columns from the list of available columns. The lookup columns are the columns in the reference table in which you want to look up values that match the input columns, which are the columns in the data flow from the source table. Your selections are reflected in the check box selections in the Available Lookup Columns table above.
- Lookup Operation
Select from the list a lookup operation to perform on the lookup column.
- Output Alias
Type an alias for the output for each lookup column. The default is the name of the lookup column; however, you can choose any unique, descriptive name.
- Configure Error Output
Specify how the component should handle row-level errors by using the Configure Error Output dialog box.
ReferenceLookup Transformation Editor (Reference Table Tab)
Lookup Transformation Editor (Advanced Tab)
Other ResourcesIntegration Services Error and Message Reference
Fuzzy Lookup Transformation
How to: Implement a Lookup Using the Lookup Transformation