DSXchange

Posted: **Tue Jan 06, 2009 6:25 pm**

I am FTPing .csv file from remote server and then concatiating it to a "R.csv" file, but when i am trying to read that "R.csv" file by using sequential stage data stage is reading just 1st row and its giving warning as "nls_read_delimited" row -1, too many column in a record"

but my data is fine can you please tell me the solution>?

R.csv---->

'99999','BB1','12/17/2008','10:01:04','000015451900110042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900210042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900310042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900410042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900510042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900610042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900710042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900810042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900910042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451901010042500000','0.15','1'

Posted: **Tue Jan 06, 2009 7:02 pm**

Your metadata defined in the Sequential stage does not match the actual file's data. Details please - how many columns did you define? What column delimiter? Etc.

Posted: **Tue Jan 06, 2009 7:46 pm**

How many columns are mentioned in the Sequential File stage in your job design?

When you say "concatenate" to R.csv, is the already existing structure of R.csv compatible with the added rows?

DSXchange

Reading .csv file.

Reading .csv file.