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

Chapter 5. Data Flow Task Part 3—Advanced Transformation

by Reza Rad

In this chapter, we will cover:

  • Pivot and Unpivot Transformations
  • Text Analysis with Term Lookup and Term Extraction transformations
  • DQS Cleansing Transformation—Cleansing Data
  • Fuzzy Transformations—how SSIS understands fuzzy similarities

Introduction

In real-world scenarios different data sources do not provide the same structure, so there is a need to unify them in a unique structure. There are some transformations in the SSIS Data Flow task that use complex ways to apply such changes on the data stream, we call them Advanced Transformations.

There are some times when values in each row in a specified column should be transformed into columns based on a key. The Pivot Transformation ...

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