term lookup transformation in ssis

The Term Lookup Transformation in SSIS is used to find terms within the string or text. It uses the reference table (contains terms) to find the matched sentences from the source data and also counts the number of times a term is repeated in the source data row. The SSIS Term Lookup transformation adds two … Read more