SSIS Set Variable Task allows you to set the value of a variable at runtime and is often best used in combination with an expression to set the value. It's pretty easy to use and even comes with its own UI which allows you to choose from the available variables and set a static value.
Comments