DSXchange

Hi,
My requirement is to check the value for a particular field.If the value is null then send the entire record to error table else pass it to output.

I am using the following condition in the constraint field.

IsNull(input column)

the job executes well but the error table is not populated with the null records.null records pass through the target.

Please help and thanks in advance.
regards

Then they're not nulls, probably just an empty string. What kind of field are we talking about? Can you try checking for both?