Databases Reference
In-Depth Information
Control Flow pane, it is time to connect the Execute DDL task to the send
mail tasks. You can connect tasks in a control flow by clicking on the originat-
ing object (a downward facing green arrow will appear) and dragging the ar-
row end to the target object. Do that for the first Send Mail task. For the
second Send Mail Task, just click the Execute DDL task again and you will
see another green arrow appear as an output of the item. Drag the green ar-
row and connect it to the next Send Mail task. Your package should look like
the one shown in
Figure 16-7
.
That connecting line represents precedence
constraint functionality; in fact, if you double-click the green line, the Preced-
ence Constraint Editor will appear. The green lines indicate success and
whenever the Execute DDL task completes successfully, execution continues
with the task connected on the success line. To configure the second mail
task to send e-mail on failure, double-click the connecting line.
1. You should see the precedence constraint editor as shown in
Figure
16-8
. The connecting line between the two tasks has several proper-
ties that are evaluated after the completion of the source task. You
can specify an expression and/or constraint that can be evaluated
after the completion of the task. The value property of the connecting
line helps you to choose the constraint and determines whether the
control will be transferred to the next task. The three options for the
value property are success, failure, and completion. Change the
value from Success to Failure. You can also configure the preceden-
ce control by right-clicking the connecting line between two tasks and
selecting Success, Failure, or Completion. Click OK after you have
completed specifying the constraint.
Search WWH ::
Custom Search