Term Lookup Transformation Editor (Reference Table Tab)

Use the Reference Table tab of the Term Lookup Transformation Editor dialog box to specify the connection to the reference (lookup) table.

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


  • OLE DB connection manager
    Select an existing connection manager from the list, or create a new connection by clicking New.

  • New
    Create a new connection by using the Configure OLE DB Connection Manager dialog box.

  • Reference table name
    Select a lookup table or view from the database by selecting an item from the list. The table or view should contain a column with an existing list of terms that the text in the source column can be compared to.

  • 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 (Term Lookup Tab)

Term Lookup Transformation Editor (Advanced Tab)


Integration Services Error and Message Reference

Term Extraction Transformation