开发者

SSIS - Setting a Dataflow Derived Column value from a variable

开发者 https://www.devze.com 2022-12-26 18:35 出处:网络
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.

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 开发者_StackOverflow中文版the Derived Column to make a new column and then set the value using a Script Component, but that seems inefficient.


Yes: Add the derived column component to the dataflow, then add a row and use the variable as the source. You should see Variables/Columns in the upper-left of the designer.

0

精彩评论

暂无评论...
验证码 换一张
取 消