Null values are dropped in the tranformer stage

[bhanuvlakshmi]

Hi all,

My Job is having ODBC stage --> and T/F stage--> sequential stage.
I have to handle the null values if it comes from database to either empty or to a value. I handled them using IsNull(i/pcolumn) in T/F stage.
but in output those values are not reflecting and are dropped with a warning message "Field '*****' from input dataset '0' is NULL. Record dropped."

Could any one suggest me why it is so.
for all my previous projects I use to do the same and those are working fine.

[MarkB]

Make sure in your Sequential File stage that you are setting a null value. Go to the Format Tab, and then Field Defaults. You can then specify the null value. Of course, make sure that nullable fields are also set as being nullable.

[soumya5891]

Try to use NullToValue function in a transformer stage.You can also do it in a modify stage