top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

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

+3 votes
227 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 Google+ Share Button LinkedIn Share Button Multiple Social 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
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...