DSXchange

I am having trouble reading a delimited file thru sequential file stage. It is a tab delimited file with 10 columns. My formatting options are
Final Delimter :None (tried with End too)

Delimiter = tab
Null field Value = ''
Quote = None

I am reading all the fields as Varchar. I am seeing the below error. The first value is the Company_Code.


##W IIS-DSEE-TFIG-00194 13:21:31(000) <STG_FILE,0> Delimiter for field "COMPANY_CODE" not found; input: {2 6 7 6 | 1 0 | 1 0 | 0 0 0 1 1 9 5 5 7 1 | W E | 0 0 0 | 0 0 0 1 1 9 5 5 7 1 | 20 20 20 20 20 20 20 20 20 20 | 0 0 0 0 0 0 0 0 | 0 0 0 0 0 0 0 0 0 0 0d}, at offset: 0
##W IIS-DSEE-TOIX-00154 13:21:31(001) <STG_FILE,0> Import warning at record 0.
##W IIS-DSEE-TOIX-00018 13:21:31(002) <STG_FILE,0> Import unsuccessful at record 0.


Please help.

Welcome aboard.

It seems that your file is not tab delimited but, instead, pipe-delimited.
Change the delimiter property to "|".

Never believe what anyone tells you about metadata of text files. Always check.

Amen Brother!

...then wait for the inevitable mismatch between the test files they sent you and what shows up the first day in production.