开发者

SSIS - Setting a Dataflow Derived Column value from a variable

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜