Hi All,

I have a requirement to load contents of multiple Files into a table "temp_dn" after FTPing from an Unix Server.

To load single File I have used the Below Job :

tFTPGet_1 --> tOracleBulkExec_1

and in Data File name for tOracleBulkExec_1, I have given the absolute path name for the input File FTP'd. For Ex :

"C:/Users/arunshankar.c/Desktop/Talend/abc.txt"

I was able to FTP Multiple Files by providing as "*.txt" in tFTPGet_1.

But, when I provided "C:/Users/arunshankar.c/Desktop/Talend/*.txt" in tOracleBulkExec_1. I got error stating that the file name provided was invalid.

Please suggest the steps to FTP Multiple Files and load contents of all files into a Table using tOracleBulkExec_1


Thanks & BR,
Arun