Split Conditional Field License For Free

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.

Conditional Split splits the set of records ing to criteria you define, sending subsets of records down multiple paths. Any records not caught in one of the defined conditions will be routed through a built in default-output. Like a CASE expression, each row coming into the split can only land in one output.

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.

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

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.

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.