Validating sql stored procedures

As you might have guessed from the name it is used to determine if the stored procedure needs to be called.

This sounded simple enough, except the validation routine was a stored procedure.

The file needs to be split into two distinct output paths from the same source, which means this should all happen within a given Data Flow component.

One of the paths simply sums the data via a specific set of columns, nothing unusual.

Ideally I wanted a pop-up message that I could customize based on the condition found in the stored procedure.