While the two suggestions are spot on, you do not need a script task to modify the variable value. Look at variable expressions (Highlight variable, F4). You can make the variable dynamic and do exactly what you are after.
I can't die, there are too many people who still have to meet me!
It's not a bug, SQL just misunderstood me!