top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is a Precedence Constraint and what types of Precedence Constraint are there in SSIS?

+3 votes
646 views
What is a Precedence Constraint and what types of Precedence Constraint are there in SSIS?
posted Apr 21, 2014 by Neeraj Pandey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

SSIS allows you to place as many as tasks you want to be placed in control flow. You can connect all these tasks using connectors called Precedence Constraints. Precedence Constraints allow you to define the logical sequence of tasks in the order they should be executed. You can also specify a condition to be evaluated before the next task in the flow is executed.

There are thee types of precedence constraints and the condition could be either a constraint, an expression or both

  1. Success (next task will be executed only when the last task completed successfully) or
  2. Failure (next task will be executed only when the last task failed) or
  3. Complete (next task will be executed no matter the last task was completed or failed).
answer Apr 22, 2014 by Chahat Sharma
...