Datasheet

Figure 1-11: Current control flow
Double-click the precedence constraint between the Data Flow Task (named Create Product File) and the
Stub Code Script Task. Change the Evaluation operation option to Expression and Constraint. The value
should remain Success and the Expression should read
@intCount > 400, as shown in Figure 1-12. Click
the Test button to make sure you have valid syntax. As in the rest of SSIS, variable names are always
case-sensitive. This configuration means that the Stub Code Task will execute if and only if both the Data
Flow Task succeeds and it transforms more than 400 records (read from the Row Count transform in the
data flow).
Figure 1-12: Success value and expression
16
Chapter 1: Getting Started
04_134115 ch01.qxp 4/24/07 6:40 PM Page 16