For your dataset query, are you using a text command type or stored procedure?
EDIT: I should have been more clear. You can set the parameter in the node to not accept nulls and it won't. However, if you're sending this down to a procedure you'll have some extra options available to you.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA