tftpfilelist--iterate--tfileinputdelimited iterating only once
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 .
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....
