Export (0) Print
Expand All

Term Extraction Transformation Editor (Exclusion Tab)


Applies To: SQL Server 2016

Use the Exclusion tab of the Term Extraction Transformation Editor dialog box to set up a connection to an exclusion table and specify the columns that contain exclusion terms.

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

Use exclusion terms
Indicate whether to exclude specific terms during term extraction by specifying a column that contains exclusion terms. You must specify the following source properties if you choose to exclude terms.

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

Create a new connection to a database by using the Configure OLE DB Connection Manager dialog box.

Table or view
Select the table or view that contains the exclusion terms.

Select the column in the table or view that contains the exclusion terms.

Configure Error Output
Use the Configure Error Output dialog box to specify error handling for rows that cause errors.

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

Community Additions

© 2016 Microsoft