Hello...I'm new to SSIS, but relatively seasoned with DTS. In chapter 1 on page 16, we are instructed to change a precedent constraint to Expression and Constraint. The Expression used is @intCount > 400. When I run this package, I am getting two errors, correspondingly, I have two questions:

1) shouldn't page 16 instruct that the value to be used in the expression read @[User::RowCount] > 400
2) when I run the package, an error is generated:
'Error at Chapter1: the expression "@[User::RowCount] > 400" must evaluate to True or False. Change the expression to evalutate to a Boolean Value.

I found my own answer. First, page 16 is wrong, it should either instruct you to use @RowCount > 400 or @[User::RowCount] > 400. Second, the error I was receiving was due to having the RowCount variable scoped to the Data Transform. Once I scoped it to the whole project, the error went away, and the constraint behaved predictably.

dKK

Thanks for the post! I was having the same problem and your solution worked for me also. Please post any other problems as you work through the book and I will try to do the same.

Sorry, I missed one thing. How did you 'scope' the variable to the whole project?

Thanks!

I scoped the variable to the whole package by creating the variable while the Control Flow was active. It wasn't enough to just click the control flow. I had to click something in the screen to get it to work.