liveBook · Manning

Failure constraint

As explained in 100 SQL Server Mistakes and How to Avoid Them

A failure constraint is an SSIS precedence constraint that permits a downstream task to run only after the preceding task fails.

A failure constraint is an SSIS precedence constraint that runs a downstream task only after the preceding task fails. If the preceding task succeeds, the downstream task is skipped. It supports custom error-handling logic in the control flow and appears red. section 6.0

Run recovery after failure

Connect a recovery task to a preceding task with a failure constraint. A failed preceding task triggers the recovery task; a successful preceding task does not. section 6.0

How 100 SQL Server Mistakes and How to Avoid Them covers it

How deep it goes
Defines execution behavior and visual notation, while stopping short of detailed configuration procedures.
Examples
Uses a downstream task that runs after a preceding task fails and remains skipped after success.
What it assumes
Assumes SSIS tasks and control flow, while distinguishing precedence constraints from data-flow paths.
What you can do after
Apply it to route SSIS control flow into failure-handling tasks.
How it connects
Connects precedence constraints with control flow, success constraints, completion constraints, and data paths.
Cover of 100 SQL Server Mistakes and How to Avoid Them
liveBookmanning.com
Read 100 SQL Server Mistakes and How to Avoid Them on liveBook Get the book at manning.com

Related concepts

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.