How does data get “Split”, exactly?
The Conditional Split directs entire rows to different outputs depending on whether they meet criteria that you set. The criteria are defined using SSIS’s expression language to create a statement that evaluates to True or False.You can define as many outputs as you like, and there is always one default (which you can name if you want).
When would you use a Conditional Split?
There’s a couple of scenarios that commonly crop up for using this transformation – first is when you want to direct subsets of data to different locations, such as sending centrally collected data to appropriate branches. A second is within the dataflow when you want to apply different business rules to certain subsets of the data, before recombining it to go to the same final destination. It’s fast and once you understand the syntax for the SSIS expression language, very simple to use.
Print this post
No comments:
Post a Comment