control-flow

SSIS Control Flow vs Data Flow

A data flow defines a flow of data from a source to a destination. You do not start on one data flow task and move to the next. Data flows between your selected entities (sources, transformations, destinations). Moreover within a data flow task, you cannot perform tasks such as iteration, component execution, etc. A control … Read more

How to exit an if clause

(This method works for ifs, multiple nested loops and other constructs that you can’t break from easily.) Wrap the code in its own function. Instead of break, use return. Example: