Skip to main content

Control Flow Precedence Constraints

This snippet shows some example uses of Precedence Constraints in SSIS control flow.

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
<Packages>
<Package Name="Control Flow Sample 1" AutoCreateConfigurationsType="None" ConstraintMode="Linear">
<Tasks>
<Dataflow Name="Task 1"/>
<Dataflow Name="Task 2"/>
<Dataflow Name="Task 3"/>
</Tasks>
</Package>
<Package Name="Control Flow Sample 2" AutoCreateConfigurationsType="None" ConstraintMode="Parallel">
<Tasks>
<Dataflow Name="Me First"/>
<Dataflow Name="Me Next (Success)">
<PrecedenceConstraints>
<Inputs>
<Input OutputPathName="Me First.Output"/>
</Inputs>
</PrecedenceConstraints>
</Dataflow>
<Dataflow Name="I'm Last (Always)">
<PrecedenceConstraints LogicalType="Or">
<Inputs>
<Input OutputPathName="Me First.Output" EvaluationValue="Failure"/>
<Input OutputPathName="Me Next (Success).Output" EvaluationValue="Completion"/>
</Inputs>
</PrecedenceConstraints>
</Dataflow>
</Tasks>
</Package>
<Package Name="Control Flow Sample 3" AutoCreateConfigurationsType="None" ConstraintMode="Parallel">
<Variables>
<Variable Name="Continue" DataType="Int32">0</Variable>
</Variables>
<Tasks>
<Dataflow Name="Task 1"/>
<Dataflow Name="Task 2">
<PrecedenceConstraints>
<Inputs>
<Input OutputPathName="Task 1.Output" EvaluationOperation="Expression" Expression="@Continue==1"/>
</Inputs>
</PrecedenceConstraints>
</Dataflow>
</Tasks>
</Package>
</Packages>
</Biml>