Simple Text Mining with the SSIS Term Extraction Component

Advanced analytics, big data, data science; they’re all hyped topics nowadays. They’re not new however, and one specific subject area has always had some presence in Microsoft’s ETL tool: text mining. Integration Services offers two transformations that can help you to do some rudimentary analysis on text: the Term Extraction and the Term Lookup components. This tip will introduce you to the Term Extraction component using a simple use case.