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.
How to handle the null values
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Tue Feb 13, 2007 5:30 am