Split Conditional Field Article For Free

The Conditional Split transformation can route data rows to different outputs depending on the content of the data. The implementation of the Conditional Split transformation is similar to a CASE decision structure in a programming language.

Drag the conditional split component from the sidebar and drop it where you would like to create this split. You will automatically see a YES and NO path appear below it. If you insert a conditional split midway into a flow, all components below that point will be placed on the YES path by default.

Conditional splits divide recipients based on what their actions or profile properties. If you split recipients by their actions, you need to allow time for them to complete it.

Add a SSIS Conditional Split Transformation to the Data Flow It moves the data to an appropriate destination depending upon the condition. Drag the SSIS Conditional Split task from the SSIS Toolbox. Now, Connect the Source Data (OLE DB Source) to the Conditional Split transformation task.

The Conditional Split transformation checks the given condition and route data to appropriate destination depending on the given condition. For example if a men's age is greater than 66 then He can go it into the Senior citizen quota or else He will not be considered as senior citizen.

The lookup gets information from an outside source, while the conditional split does not.

The difference between the two is that the Multicast transformation directs every row to every output, and the Conditional Split directs a row to a single output. For more information, see Conditional Split Transformation. You configure the Multicast transformation by adding outputs.