How to deal with flat file downloads in Integration Cloud?

[Anonymous]

Hi folks,

We just purchased Talend Integration Cloud and I am working to migrate a job I've created in regular studio on my PC and then ran using Windows Scheduler.

The job imported a .csv file from an SFTP server, deposited it into a folder on the PC, then did work on it, and uploaded it elsewhere.

But when I host a job on Integration Cloud, there is no folder for me to download to, and I can't access my flat files without downloading them first to a location it seems.

I know this must be basic for many, but what should I do?

[Anonymous]

Hi
You can download it to location on server , such as "/tmp/" , and delete the file in the end of job, check the file if it exists and delete it.

tpostJob--oncomponentok-->tFileExist--runif--tFileDelete

Regards
Shong

[Anonymous]

Hi Shong,

So I went to try this out by going to my local job and changing the local directory from "C:/xxxx/yyy.csv" to "/tmp/yyy.csv" in the tFTPGet, and all subsequent components.

But I got the error that "The system cannot find the file specified".

Am I using the wrong component?

[Anonymous · Accepted solution]

Shong,

I was able to resolve this using an answer you gave to another question.

Thank you.