开发者

SSIS, outputting null as a column value within a script task

开发者 https://www.devze.com 2023-01-22 01:33 出处:网络
I have a synchronous transformation script compon开发者_如何转开发ent, with some input columns, and an extra defined Output column \"ID\". ID outputs an integer (DT_I4) type. Under certain circumstanc

I have a synchronous transformation script compon开发者_如何转开发ent, with some input columns, and an extra defined Output column "ID". ID outputs an integer (DT_I4) type. Under certain circumstances, I would like "ID" to output a null value from my script.

Assigning it a null value in other SSIS components works, I can use NULL(DT_I4) within a derived column for example, but I cannot figure out how to do this in a script.

Row.ID = null;

claims that ID is not a nullable value type.

I use c# within my scripts.

Is there any way to do this?

Edit: To make life easier, "ID" would ideally output a value of NULL by default if it is not assigned anywhere within the script using Row.ID = ...;


Every column has a booelan property called ColumnName_IsNull (in your case should be Row.ID_IsNull). I think you should set it to true to set the columns value NULL

0

精彩评论

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