SSIS: Precedence Constraints

Controlling the execution sequence of tasks.

I’ll begin by dragging these tasks unto the designer: Execute SQL, Data Flow, and Send Mail.
Then, connect the Execute SQL task’s green arrow to the Data Flow task.

1-precedence-constraints

Right-click the new constraint and verify these values.

Drag new constraints between the Execute SQL task, Send Mail task, and the Data Flow task.

3-precedence-constraints

Then, change the constraint between the Send Mail task and the Data Flow task so that if the Execute SQL task fails, an email is sent.

4-precedence-constraints

Based on both failure constraints, email will only be sent if either the Execute SQL or Data Flow tasks fail.

Since we want the email sent if either task fails, double-click one of the constraints and change the “Multiple Constraint” setting to “Logical OR…

Now, the constraints’ dotted red line indicate if either task fails (not both), an email is sent.

6-precedence-constraints

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s