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.

Options

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.