Precedence Constraint can be of 3 types:
- Success – indicated by Green arrow
- Failure – indicated by Red arrow
- Completion – indicated by Blue arrow
Whenever you drag any task from SSIS toolbox to the designer, you must have noticed a green arrow coming from task. To create a Precedence Constraint, you need to connect this arrow with another task\ container.
On double clicking the constraint following dialogue box will open:
One can perform following things on Precedence Constraint:
- Write Constraints
- Write Expressions
- For multiple constraints you can choose Logical And/ Logical Or
No comments:
Post a Comment