Export (0) Print
Expand All
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft