Term Lookup Transformation Editor (Term Lookup Tab)

Use the Term Lookup tab of the Term Lookup Transformation Editor dialog box to map an input column to a lookup column in a reference table and to provide an alias for each output column.

To learn more about the Term Lookup transformation, see Term Lookup Transformation.


  • Available Input Columns
    Using the check boxes, select input columns to pass through to the output unchanged. Drag an input column to the Available Reference Columns list to map it to a lookup column in the reference table. The input and lookup columns must have matching, supported data types, either DT_NTEXT or DT_WSTR. Select a mapping line and right-click to edit the mappings in the Create Relationships dialog box.
  • Available Reference Columns
    View the available columns in the reference table. Choose the column that contains the list of terms to match.
  • Pass-Through Column
    Select from the list of available input columns. Your selections are reflected in the check box selections in the Available Input Columns table.
  • Output Column Alias
    Type an alias for each output column. The default is the name of the column; however, you can choose any unique, descriptive name.
  • Configure Error Output
    Use the Configure Error Output dialog box to specify error handling options for rows that cause errors.

See Also


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

Other Resources

Integration Services Error and Message Reference
Term Extraction Transformation

Help and Information

Getting SQL Server 2005 Assistance