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 4. Data Flow Task Part 2—Transformations

by Reza Rad and Pedro Perfeito

In this chapter, we will cover the following topics:

  • Derived Column: adding calculated columns
  • Audit Transformation: logging in Data Flow
  • Aggregate Transform: aggregating the data stream
  • Conditional Split: dividing the data stream based on conditions
  • Lookup Transform: performing the Upsert scenario
  • OLE DB Command: executing SQL statements on each row in the data stream
  • Merge and Union All transformations: combining input data rows
  • Merge Join Transform: performing different types of joins in Data Flow
  • Multicast: creating copies of the data stream
  • Working with BLOB fields: Export Column and Import Column transformations
  • Slowly Changing Dimensions (SCDs) in SSIS

Introduction

Transforming ...

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