topic Re: Loading files from aws s3 folder (smart_sent_2022-06-11) to Oracle in Talend Studio

Loading files from aws s3 folder (smart_sent_2022-06-11) to Oracle

HBramhaiah — Fri, 15 Nov 2024 22:50:38 GMT

In tS3List component i used the key prefix is : "smart_sent_"+TalendDate.getDate("CCYY-MM-DD"), But i am not getting files.

The error i got in tS3Get component is shown below.

Error message : java.io.FileNotFoundException: C:\Users\hp\Desktop\talend\smart_sent_2022-06-11\Employee.txt (The system cannot find the path specified)

Re: Loading files from aws s3 folder (smart_sent_2022-06-11) to Oracle

Anonymous — Sun, 12 Jun 2022 02:40:13 GMT

@Harijana Bramhaiah can you share a screenshot of basic settings of tS3Get component? The file path mentioned in the error is the value you input in the File field? This is the name of file to be saved locally.

Regards

Shong

Re: Loading files from aws s3 folder (smart_sent_2022-06-11) to Oracle

HBramhaiah — Sun, 12 Jun 2022 03:24:21 GMT

Dear All,

Please find the attachment

tS3List Key prefix : "smart_sent_"+TalendDate.getDate("CCYY-MM-DD")

Re: Loading files from aws s3 folder (smart_sent_2022-06-11) to Oracle

Anonymous — Mon, 13 Jun 2022 03:06:21 GMT

It seems the folder (smart_sent_2022-06-11) does not exist

directory path: C:\Users\hp\Desktop\talend\smart_sent_2022-06-11\

file name: Employee.txt