SSIS set variable at runtime

variables ssis
Arcadian picture Arcadian · Oct 29, 2010 · Viewed 62.3k times · Source

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

Chris Voon picture Chris Voon · Oct 3, 2013

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...

Expression Builder

Related questions

SSIS Result set, Foreachloop and Variable

I'm having an issue and I don't know if this is possible to do. I have a simple SQL task. SELECT Name, email FROM table_name Using a result set, I'm trying to pass it to a variable and use …

Read More
SSIS Element cannot be found in a collection (but I have them all listed!)

I'm getting a persistent error: The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during execution of the package and the element is not there. …

Read More
How to store 'fully qualified' and 'name only' file name in SSIS variable

I have an SSIS package that has a Foreach Loop container loading all .txt files in a static folder. I'm passing the fully qualified file name as a variable which I'm using in the connection string. I now need to …

Read More