Articles tagged

07 July 2009
07 July 2009

Working with Precedence Constraints in SQL Server Integration Services

12
275
In SSIS, tasks are linked by precedence constraints. A task will only execute if the condition that is set by the precedence constraint┬ápreceding the task is met. By using these constraints, it is possible to ensure different execution paths depending on the success or failure of other tasks. This means that you can use tasks with precedence constraints to determine the workflow of an SSIS package. We challenged Rob Sheldon to provide a straightforward practical example of how to do it. … Read more