Page 1 of 1
Can anybody help me fix this warning.
Posted: Mon May 21, 2007 6:48 am
by Minhajuddin
Hi all,
Can anybody help me fix this warning.
I have a source file(sequential), a transformer, and a target sequential file
The delimiter in these files is '|' and I these are DOS files. I even set the Record Delimiter String as 'DOS FORMAT"
Sequential_File_0,0: Field "SUMMARY_BILL_DATE" delimiter not seen, at offset: 184
Thank you.
Posted: Mon May 21, 2007 6:56 am
by keshav0307
is SUMMARY_BILL_DATE the last field,
May be the final delimiter not defined correctly
Re: Can anybody help me fix this warning.
Posted: Mon May 21, 2007 9:45 am
by HanuKoya
You have to check your source data. I guess your source data doesn't have delemiter "|"
Posted: Mon May 21, 2007 3:28 pm
by ray.wurlod
Check (don't assert) that the delimiter in the file is "|" and that the delimiter character specified in the Format properties is also "|". Whatever the delimiter character is in the file, make it the same in the Format properties.
Posted: Tue May 22, 2007 1:29 am
by rafik2k
Can you post some sample data?
Posted: Tue May 22, 2007 9:48 pm
by Minhajuddin
Hi all,
Thanks for all your help!
It has been fixed.
I am highly indebted to this site. :D
Posted: Tue May 22, 2007 9:58 pm
by ray.wurlod
Help future searchers. Explain HOW it was fixed.
Posted: Wed May 23, 2007 1:03 am
by Minhajuddin
Hi Ray,
Actually the error was that some of the columns were 'CHAR' datatypes instead of 'VARCHAR'.
And When I changed it to VARCHAR it got fixed.
:D:D:D:D:D