DSXchange

I am trying to read a txt file that I put on a UNIX box. It looks like the following:

VIN|SoldDate|BuildDate|IntvDate|ProblemCode|Service|Delivery|Trans|Engine|ProblemCode|SMT|Overall|BirthYear|Mcell|Qcell|Verbatim

I have these settings:
Final delimiter = end
Record = UNIX
Record Delimiter = |
Quote = none

It stops at the second column (SoldDate)

Is there a setting I am missing?

'|' is your field delimiter and not record delimiter.

Is your file coming with null value?
What is the datatype you have given for Date,read it as varchar and transform to date in Transformer.

lsnovick wrote:It stops at the second column (SoldDate)

Change the Data type as VC and handle it in the next TFM would allow you...

... or just fix the field and record delimiters.

are running this job with RCP or normal

'|' is the field delimiter not the record delimiter.Remove the record delimiter property and add field delimiter ='|'