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.

Options

  • 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.

See Also

Reference

Lookup Transformation Editor (Reference Table Tab)
Lookup Transformation Editor (Advanced Tab)

Other Resources

Integration Services Error and Message Reference
Fuzzy Lookup Transformation
How to: Implement a Lookup Using the Lookup Transformation

Help and Information

Getting SQL Server 2005 Assistance