Field 'Name' from input dataset '0' is NULL. Record dropped.
Posted: Fri Mar 18, 2011 4:39 am
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.
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.