1.

What Is A Precedence Constraint And What Types Of Precedence Constraint Are There?

Answer»

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.

These are the types of precedence constraints and the condition could be either a constraint, an expression or both Success (next task will be executed only when the last task completed successfully) or Failure (next task will be executed only when the last task failed) or Complete (next task will be executed no matter the last task was completed or failed).

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.

These are the types of precedence constraints and the condition could be either a constraint, an expression or both Success (next task will be executed only when the last task completed successfully) or Failure (next task will be executed only when the last task failed) or Complete (next task will be executed no matter the last task was completed or failed).



Discussion

No Comment Found