SSIS set variable at runtime

Question

Anyone know how I can change a SSIS variable at runtime?

I have a variable User:SkipStuff

I want to set this based on a condition during a for loop container

Answer 1

Lots of ways really, but the one I use most frequently is to use an execute SQL task and set the result set to single row and then put the results set into the variable.

Answer 2

You can add a Script task. Add your SSIS variable(s) to the ReadWriteVariables property in the Script Task Editor.

You can reference the variable(s) in your script using the following format: Dts.Variables["MyCaseSensitiveVariableName"].Value