Page 1 of 1

sequential file warning message

Posted: Thu Sep 13, 2007 4:12 am
by scorpion
Hi All,

I am getting some warning messages in my director log like below.

Input_Delta,0: Field "LT_SZE" has import error and no default value; data: <empty>, at offset: 202


This is message belongs to one sequential file stage.

Any one has idea?

Re: sequential file warning message

Posted: Fri Sep 21, 2007 1:39 pm
by surendra_ds
Hi

The Error comes when u are trying to write into a sequential file. Make sure that all the settings are proper.

Posted: Fri Sep 21, 2007 3:45 pm
by ray.wurlod
Not correct.

Import errors occur when you are trying to READ.

And is agnostic regarding what U might be doing at the time.

The field in question is empty, but your data type precludes an empty string being a valid value. You need to provide either a Default property or a Null Field Value property or both for this field.

Posted: Thu Sep 27, 2007 8:23 am
by mcs_dineshm
There may be data type mismatch,so try it up with some other datatype. Varchar is more preferred if the field contains special characters,characters and numbers