Term Lookup Transformation Editor (Reference Table Tab)


Applies To: SQL Server 2016

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.

Integration Services Error and Message Reference
Term Lookup Transformation Editor (Term Lookup Tab)
Term Lookup Transformation Editor (Advanced Tab)
Term Extraction Transformation

Community Additions