A
task will only execute if the condition that is set by the precedence
constraint preceding the task is met. By using these constraints, it will
choose different execution paths depending on the success or failure of other
tasks.
Success – Workflow will proceed when the preceding
container executes successfully. Indicated in control flow by a solid green
line.Failure – Workflow will proceed when the preceding container’s execution results in a failure. Indicated in control flow by a solid red line.
Completion – Workflow will proceed when the preceding container’s execution completes, regardless of success or failure. Indicated in control flow by a solid blue line.
Expression/Constraint with Logical AND – Workflow will proceed when specified expression and constraints evaluate to true. Indicated in control flow by a solid color line along with a small 'fx' icon next to it. Color of line depends on logical constraint chosen (e.g. success=green, completion=blue).
Expression/Constraint with Logical OR – Workflow will proceed when either the specified expression or the logical constraint (success/failure/completion) evaluates to true. Indicated in control flow by a dotted color line along with a small 'fx' icon next to it. Color of line depends on logical constraint chosen (e.g. success=green, completion=blue).
LABEL: SSIS INTERVEIW QUESTIONS
No comments:
Post a Comment