O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Text Analysis with Term Lookup and Term Extraction transformations

There are a lot of transformations that help you to analyze numeric data. You can even use aggregate functions in T-SQL to fetch analytic information from numeric data; but what happens when you want to analyze user comments? Those can be freeform texts without any categorization.

Text Analysis is a complete topic in the data analysis category, which discusses fetching analytical information from text data; the text data can be completely freeform text data. Fortunately SSIS provides two useful and advanced transformations for Text Analysis called Term Extraction and Term Lookup.

In this recipe, we will take a look at how we can analyze and mine free text data. Assume that customers ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required