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

Question

I have a synchronous transformation script component, 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 = ...;

il_guru · Accepted Answer · 2010-10-27 15:47:45Z

35

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

answered Oct 27, 2010 at 15:47

il_guru

8,5483 gold badges46 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

John Over a year ago

Excellent, just the answer I was looking for. Thanks.

Goku Over a year ago

That didn't work for me, all I get back is false, but i don't get the lines where there is a text or numeric value expected.

user17248421 Over a year ago

stackoverflow.com/questions/72149895/…

Collectives™ on Stack Overflow

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

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related