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

Conditional Split: dividing the data stream based on conditions

This recipe demonstrates the use of the Condition Split component, which is one of the most used components and is responsible for splitting data into several destinations. It's applied when data in a specific stage of the pipeline needs to follow a different path based on logical conditions. At a later stage all the data divided could be joined again using the Union All or even the Merge transformation referred in a later recipe in this chapter.

Conditional Split: dividing the data stream based on conditions

Getting ready

To get ready for this recipe, use the following steps:

  1. Open SQL Server SQL Server Data Tools (SSDT) and create a new SSIS project. ...

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