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.
Getting ready
To get ready for this recipe, use the following steps:
Open SQL Server SQL Server Data Tools (SSDT) and create a new SSIS project.
Provide a name and location for the SSIS project and then proceed.
Select the package created by default and rename it to
P01_ConditionalSplit.dtsx.
How to do it...
In a Data Warehousing scenario, this component is not only very useful in order to apply business rules to the data extracted from sources, but also to apply some data quality validations...
