How to handle the null values

[Sridhar Sivakoti]

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.

[ArndW]

Although this is a topic that has seen a lot of posts, I'll make a stab at an answer. Somewhere in your stage you are using DMA_CODE without having handled nulls. Remember, this also includes use of constraints.