ftp not retrieving all records
Moderators: chulett, rschirm, roy
ftp not retrieving all records
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
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
Re: ftp not retrieving all records
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 wrote:...My source file is located on ftp...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Here the file is delimited with comma, Line termination is [CR][LF] (DOS Style Termination)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)
With regards,
Xpert
Xpert
(Are both Xpert and Mohanraj working the same problem?)
Does adding a <cr><lf> to the source file fix the problem?
Does adding a <cr><lf> to the source file fix the problem?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I got the answer, thnx a lot.....Xpert wrote:Here the file is delimited with comma, Line termination is [CR][LF] (DOS Style Termination)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)
With regards,
Xpert
Xpert
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: