Control Flow It is called “control flow” because this is where you design the sequence of steps in your package and direct how they flow from one to the next. There are four main types of items and objects in the Control Flow tab. Control Flow Tasks Precedence Constraints Containers Connection Managers The most commonly used Control Flow tasks are grouped under the Common section in the SSIS Toolbox window. This task can be done against the Filesystem level, Database level, Analysis Services level, Package level, Hadoop level, etc. to consume, transform, and load data. Precedence Constraints You can control the sequence of tasks that get executed based on completion, success, or failure of a task. On Success (Green arrow) Proceeds to the next step only if the current step completes with Success. On Completion (Black arrow) Proceeds to the next step regardless if current step completes with a Success or Failure. On Failure (Red arrow) P...
Comments
Post a Comment