Chapter 11

Advanced Data Cleansing in SSIS

WHAT’S IN THIS CHAPTER?

• Using the Derived Column Transformation for advanced data cleansing
• Applying the Fuzzy Lookup and Fuzzy Grouping Transformations and understanding how they work
• Introducing the SQL Server 2012 technology Data Quality Services

In this chapter, you will learn the ins and outs of data cleansing in SSIS, from the basics to the advanced. In a broad sense, one of SSIS’s main purposes is to cleanse data — that is, transform data from a source to a destination and perform operations on it along the way. In that sense, someone could correctly say that every transformation in SSIS is about data cleansing. For example, consider the following transformations:

• The Data Conversion adjusts data types.