Term Extraction Transformation Editor (Exclusion Tab)

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.
  • 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.
  • Column
    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.

See Also


Term Extraction Transformation Editor (Term Extraction Tab)
Term Extraction Transformation Editor (Advanced Tab)

Other Resources

Integration Services Error and Message Reference
Term Lookup Transformation

Help and Information

Getting SQL Server 2005 Assistance