tftpfilelist--iterate--tfileinputdelimited iterating only once

Anonymous — Thu, 29 Dec 2016 03:08:25 GMT

I want to process remote ftp files and i used tftpfilelist to get the list of files and connected to tfileinputdelimited to capture the data from the file into postgresql database table. But i can't get it to read more than one file from the tftpfilelist. It processess only one file and on the next iterate an errors are thrown with no file or directory message . Although it does shows the file name its trying to process in the error but can't seems to find it. Please Help!!!!!!!. I have attached a screen shot of the jobs.

I am reading the file name in tfileinputdelimited component using the tftpfilelist_1_CURRENTPATH .

Re: tftpfilelist--iterate--tfileinputdelimited iterating only once

Anonymous — Thu, 29 Dec 2016 07:07:21 GMT

Hi
tFileinputdelimited can only read local file, are your FTP server and studio on the same machine? Generally, you need to iterate each FTP files and download them to local system, and then read each file one by one.
tFTPfilelist--iterate--tftpget
|
onsubjobok
|
tfilelist--iterate--tfileinputdelimited....

Regards
Shong

topic Re: tftpfilelist--iterate--tfileinputdelimited iterating only once in Talend Studio

tftpfilelist--iterate--tfileinputdelimited iterating only once

Re: tftpfilelist--iterate--tfileinputdelimited iterating only once