ssisconditional-split

ssis conditional split not executing all conditions


In the SSIS I have the conditions seen in the image. When I run the package all conditions process except the ActivityChange. If I run the package again Activity Change is executed. Both RecordChange and ActivityChange feed to an OLE DB Command that does an update. In my testing I am using one record where the activity date and record id are being updated. Does that affect how the split is processed? If so what is another way I can ensure the activitychange is processed?

SSIS Conditional Split


Solution

  • A record that flows into a Conditional Split transformation will only take one exit which is the output with the first matching condition. That's why a Conditional Split usually is configured with conditions that are mutually exclusive.

    If more than one condition can be true and you want to process them all, you will have to use several Conditional Split transformations, either as a sequence (with the "processing" tasks in between) or in parallel (with a preceding Multicast transformation).