SSIS Question:

What is precedence constraint?

Tweet Share WhatsApp

Answer:

A precedence constraint is a link between 2 control flow tasks and lays down the condition on which the second task is run. They are used to control the workflow of the package. There are 3 kinds of precedence constraint – success (green arrow), failure (red arrow) or Completion script task (blue arrow). By default, when we add 2 tasks, it links by green arrow. The way the precedence constraint is evaluated can be based on outcome of the initial task. Also, we can add expression to evaluate such outcome. Any expression that can be judged as true or false can be used for such purpose. The precedence constraint is very useful in error handling in SSIS package.

Download SQL Server Integration Services PDF Read All 9 SQL Server Integration Services Questions
Previous QuestionNext Question
If you want to send some data from Access database to SQL server database. What are different component of SSIS will you use?Explain why variables called the most powerful component of SSIS?