SSIS - Setting a Dataflow Derived Column value from a variable

Posted by Jason W on Stack Overflow See other posts from Stack Overflow or by Jason W
Published on 2010-04-15T13:49:46Z Indexed on 2010/04/15 13:53 UTC
Read the original article Hit count: 195

Filed under:

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.

© Stack Overflow or respective owner

Related posts about ssis