Hi All,
I am using sql server 2005 as source to extract the date into the sequential file, in which one of the coulumn is nullable both on the source and the target as well. when I excute the job, I am getting an error:
Field 'ClmnName' from input dataset '0' is NULL. Record dropped.
I tried null handling functions like nulltovalue and nulltoempty and Isnull as well. But still I am getting the same error.
Could you please help out from this issue.
Thanks,
Anand.
Field 'Name' from input dataset '0' is NULL. Record dropped.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 29
- Joined: Tue Feb 16, 2010 8:47 am
What type of stage is the message coming from? It sounds like a transformer. If so, here are two possible solutions:
1) Copy the column to a stage variable, using the nullhandling logic such as NullToZero(), NullToEmpty(), NullToValue(). Then reference the stage variable in your derivations rather than the input link column
2) You may need to adjust your derivation logic so that nulls are handled separately from other conditions. For instance:
can cause the record to be dropped when colname is Null. All expressions within an If condition are evaluated before then and else. The proper way to write the above logic to handle the nulls would be:
Regards,
1) Copy the column to a stage variable, using the nullhandling logic such as NullToZero(), NullToEmpty(), NullToValue(). Then reference the stage variable in your derivations rather than the input link column
2) You may need to adjust your derivation logic so that nulls are handled separately from other conditions. For instance:
Code: Select all
If (IsNull(colname) or colname = 'A') then 1 else 0
Code: Select all
if IsNull(colname) then '1' else if colname = 'A' then 1 else 0
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 29
- Joined: Tue Feb 16, 2010 8:47 am