DSXchange

Hi, I am wrting to a sequential file and I have a column name A - varchar(25) and it is nullable, in the transformer I have used NullToEmpty and I am still getting a warning - Exporting nullable field without null handling properties.

Please help me remove these warnings.

Thanks, as always

I am assuming that this is your job design, at least part of it:

SeqFile --> Xfm

You have to have it nullable in the SeqFile stage and Not Nullable on the output of the transformer.

Just to keep it happy set the Null Field Value property for this field to "" (indeed, having done so, you could remove the NullToEmpty transformation).

Thanks, that did the trick for me.

In the transformer output link have you changed the column from nullable to not nullable in keeping with the NullToEmpty transform?