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.


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.