DSXchange

Hello,
I one of our jobs we are comparing date with max of that date field from previous day data, i am using this condition in Tx Constraint. but in our source data we have some records with null values in the date field, and comparision failing because of that, I want to give some value in place of null. so that my comparision does not fail, i want give some (01/01/1900) in place of null,

any idea/suggestion please..

There should be a NullToValue transform in there, if not it would be easy enough to create one. Check NullToEmpty and NullToZero for inspiration.

If you are querying the source then best thing would be a null handker in the query itself

Like in Sqlserver Isnull(col,'01/01/2009')

If you problem is solved then
please make this topic as resolved.....