Saturday, March 7, 2015

SSIS - Precedence Constraint




On Success : Process moves on next available task only on current task complete successfully
On Failure : Process moves on next available taks only on current task complete with failure
On Completion : Process moves on next available task, no matter current task success or fail

Constraint Options: Precedence constraints set with below evaluation operations
Constraint : evaluate only constraint
Expression : evaluate only expression
Constraint and Expression : evaluate expression as well as constraint
Expression Or Constraint : evaluate either expression or constraint

More over if the task has more than one precedence constrain, we can define "logical and" and "logical or" between these constraints

Logical and / Logical Or apply only when a task has more than one input precedence constraint.



No comments:

Post a Comment