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.
Warning:-Field 'valid_member' from input dataset '0' is NULL
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>