How to handle the null values
Posted: Tue Aug 14, 2007 3:18 am
Hi,
I have designed a job, In which one column is defined as Varchar in source and target(Both are SQL Server tables). Source table contains Null values for this column.I have taken in source and target this column metadata Nullable option as YES.When I am running this job this record is dropping at transformer, even I used Null handling functions like NullToZero and NullToValue.
I am getting below warning and records are dropping.
APT_CombinedOperatorController,0: Field 'DMA_CODE' from input dataset '0' is NULL. Record dropped.
Please help on this.
Thanks in Advance.
I have designed a job, In which one column is defined as Varchar in source and target(Both are SQL Server tables). Source table contains Null values for this column.I have taken in source and target this column metadata Nullable option as YES.When I am running this job this record is dropping at transformer, even I used Null handling functions like NullToZero and NullToValue.
I am getting below warning and records are dropping.
APT_CombinedOperatorController,0: Field 'DMA_CODE' from input dataset '0' is NULL. Record dropped.
Please help on this.
Thanks in Advance.