SSIS, outputting null as a column value within a script task
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
精彩评论