A data path connects SSIS data-flow components and routes rows according to the preceding component’s processing result. Do not confuse it with a control-flow precedence constraint: both coordinate execution, but they govern different things. section 6.0
Mistake: expecting a completion data path
A blue data path passes rows that successfully leave a component; a red data path passes rows that fail it. There is no completion data path. Completion belongs to control-flow constraints, where the connected task runs regardless of success or failure. section 6.0
Use these distinctions when designing an SSIS package:
- Create the data flow as a task on the control flow, then open its Data Flow tab to add components and paths. section 6.0
- Treat the path color as row-processing behavior, not as task-execution status. section 6.0
