liveBook · Manning

Completion constraint

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

A completion constraint is an SSIS precedence constraint that permits a downstream task to run after the preceding task executes regardless of its outcome.

A completion constraint is an SSIS precedence constraint that runs a downstream task after the preceding task executes, whether that task succeeds or fails. section 6.0

Use the connector types to express the required control-flow condition:

  • Success constraints run the next task only after success. section 6.0
  • Failure constraints run the next task only after failure. section 6.0
  • Completion constraints run the next task after either outcome and appear blue in the SSIS control flow. section 6.0

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

How deep it goes
Defines unconditional post-execution behavior, contrasts success and failure constraints, and distinguishes control-flow constraints from data-flow paths.
Examples
Uses a blue control-flow connector and contrasts it with green success and red failure connectors.
What you can do after
Configure downstream SSIS tasks to run after either success or failure of a predecessor.
How it connects
Connects precedence constraints with SSIS control flow, success constraints, failure constraints, tasks, and data flow.
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.