ftp not retrieving all records

mohanraj · Post by **mohanraj** » Tue Aug 29, 2006 3:19 am

Hi to all

My source file is located on ftp and it contains 2 records.
My problem is my job is running fine ,but it is retrieving only one record. Can anyone tell me what might be the problem and how can solve it/

Thanks in advance

Mohan

mohanraj · Post by **mohanraj** » Tue Aug 29, 2006 3:51 am

hi

Now I checked with more number of records,but it is retrieving all records except the last record
what might be the reason? please help me out.

mohan

ArndW · Post by **ArndW** » Tue Aug 29, 2006 4:15 am

mohanraj wrote:...My source file is located on ftp...

I'm not sure what that means. Does this mean you are using an FTP stage to read your source file? If the last record then it might be because of a missing terminator. What settings are you using?

mohanraj · Post by **mohanraj** » Tue Aug 29, 2006 5:38 am

Hi arndW

What you thought is right.My job is as follows

FTP------->Transformer------------>OCI

My problem is the source file contains n records,but my FTP stage is retrieving only n-1 records.What shall I have to do so that I will retrieve all the n records.

Thanks in advance
Mohan

ArndW · Post by **ArndW** » Tue Aug 29, 2006 5:44 am

What have you specified in your FTP stage? Is your file fixed width or delimited? What is your final delimiter set to (n.b. it is missing in the file, if you add a <CR> to the source file it will probably go through without a problem)

Xpert · Post by **Xpert** » Tue Aug 29, 2006 5:56 am

ArndW wrote:What have you specified in your FTP stage? Is your file fixed width or delimited? What is your final delimiter set to (n.b. it is missing in the file, if you add a <CR> to the source file it will probably go through without a problem)

Here the file is delimited with comma, Line termination is [CR][LF] (DOS Style Termination)

ArndW · Post by **ArndW** » Tue Aug 29, 2006 6:02 am

(Are both Xpert and Mohanraj working the same problem?)
Does adding a <cr><lf> to the source file fix the problem?

ray.wurlod · Post by **ray.wurlod** » Tue Aug 29, 2006 6:02 am

Is the final line in the file properly terminated?

Xpert · Post by **Xpert** » Tue Aug 29, 2006 6:03 am

Xpert wrote:
ArndW wrote:What have you specified in your FTP stage? Is your file fixed width or delimited? What is your final delimiter set to (n.b. it is missing in the file, if you add a <CR> to the source file it will probably go through without a problem)
Here the file is delimited with comma, Line termination is [CR][LF] (DOS Style Termination)

I got the answer, thnx a lot.....

ray.wurlod · Post by **ray.wurlod** » Tue Aug 29, 2006 6:06 am

Then share it. That's what makes DSXchange the incredibly useful facility that it is.

ftp not retrieving all records

ftp not retrieving all records

Re: ftp not retrieving all records