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/
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?
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.
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)
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 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)