Warning:-Field 'valid_member' from input dataset '0' is NULL

ravibabu · Post by **ravibabu** » Mon Jun 04, 2007 5:49 am

Hi,

Pls help me out from below warning.How resolve the warning.

t1xfrm_Member,0: Field 'valid_member' from input dataset '0' is NULL. Record dropped.

Thanks
Ravi.

JoshGeorge · Post by **JoshGeorge** » Mon Jun 04, 2007 6:37 am

You are trying to map a nullable column to a non-nullable column. You might want to use IsNull function and find if the source column is null and if it is substitute to empty or something else of your preference.