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.
See Also
Reference
Term Lookup Transformation Editor (Term Lookup Tab)
Term Lookup Transformation Editor (Advanced Tab)
Other Resources
Integration Services Error and Message Reference
Term Extraction Transformation