开发者

SSIS: How to reference input columns in a Component Script?

开发者 https://www.devze.com 2023-01-25 09:07 出处:网络
I need to reference a column in a component s开发者_如何转开发cript to add it\'s value to a string builder.From there i need to send the string builder to an output column.

I need to reference a column in a component s开发者_如何转开发cript to add it's value to a string builder. From there i need to send the string builder to an output column.

thanks


On the Script Component Editor on the Input columns tab, check off the column that you need. That will add two properties to your input buffer (usually called row unless you changed it): yourvariable and yourvariable_isnull. The value you need is in row.yourvariable.

0

精彩评论

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

关注公众号