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

Use Expression Task instead. In the "Expressions" pane, put the variable to set on left, then equates it to the intended value.

@[User::VariableToSet] = some expressions...

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