Null values are dropped in the tranformer stage
Posted: Wed May 25, 2011 6:50 am
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.
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.