SSIS - Setting a Dataflow Derived Column value from a variable
- by Jason W
I have an ID in a package variable that I need to add as a column (with each row having that package variablevalue) in a Dataflow.
Is there a way to do this with only the Derived Column? I know i can using the Derived Column to make a new column and then set the value using a Script Component, but that seems inefficient.