topic Re: file ftp'd from remote to local throws error when reading the file in Talend Studio

file ftp'd from remote to local throws error when reading the file

Anonymous — Sat, 05 Oct 2019 17:05:29 GMT

Hi Team,

I had ftp 'd a file from remote server to my local server with filemask option specified as

context.filename+context.rundt+context.extension and the file got ftp'd successfully.

But when i tried to read the same file through tfileinput component i get the error as

"(No such file or directory)"

Below is the error message -

[FATAL] (main): goc_etl.jo_test_sftp_0_1.jo_test_sftp - tFileInputPositional_1 /local_directory_path/filename_yyyymmdd*.txt (No such file or directory).

In the tfileinput component Filename/stream i had given as

local_directory_path+context.filename+context.run_dt+context.extn.

I am new to talend and not understanding where have i gone wrong. Please guide me on this.

Re: file ftp'd from remote to local throws error when reading the file

TRF — Sat, 05 Oct 2019 18:42:25 GMT

"/local_directory_path/filename_yyyymmdd*.txt"

you need to remove the * in the filename for tFileInputPositional_1.

Re: file ftp'd from remote to local throws error when reading the file

TRF — Mon, 07 Oct 2019 20:38:03 GMT

Did this help?
If so thanks to mark your case as solved.

Re: file ftp'd from remote to local throws error when reading the file

Anonymous — Tue, 08 Oct 2019 06:52:50 GMT

Hi,

Thanks for your reply.

"/local_directory_path/filename_yyyymmdd*.txt"

you need to remove the * in the filename for tFileInputPositional_1.

Ans:In the tfileinput component Filename/stream i had given as

local_directory_path+context.filename+context.run_dt+context.extn.

Below is the error message which i get on running the job -

[FATAL] (main): goc_etl.jo_test_sftp_0_1.jo_test_sftp - tFileInputPositional_1 /local_directory_path/filename_yyyymmdd*.txt (No such file or directory).

Re: file ftp'd from remote to local throws error when reading the file

Anonymous — Tue, 08 Oct 2019 15:04:05 GMT

No ..because i havent given * in the tfileinputpositional component. what i had given was
local_directory_path+context.filename+context.run_dt+context.extn.

Re: file ftp'd from remote to local throws error when reading the file

TRF — Wed, 09 Oct 2019 06:34:18 GMT

* is a special character (joker).
Cannot be part of a real filename.