Also, in the example in this article you can do away with the SQL statement and enter the expression directly into the variable.

+ Select the variable and go to it's properties.

+ Change the option "EvaluateAsExpression" to true, then click in the Expression option and open the expression builder.

+ Use this to build your variable's value.

Just another way in SSIS to get things done.