Hands-On Microsoft SQL Server™ 2005 Integration Services

Precedence Constraints

While creating the workflow and linking tasks, you can decide the conditions, which can affect the running of successive tasks. To do this, you use precedence constraints when linking two or more executables. Within the SSIS world, an executable is defined as a container, a task, or an event handler. The executable for which you define the precedence constraint to be applied after it has run is called the precedence executable and the executable for which you define a precedence constraint to be applied before it could run is called the constrained executable. The precedence constraints can be affected by the execution result of the precedence executable. For example, you may wish to stop the constrained executable from ...