Transfer of files from remote sftp server to local folder
Hi,
Please tell me how could I transfer the files from remote sftp server to my local directory when a job is executed daily.
Consider that there might be numerous files in the remote server such as:
abc.txt
def.txt
ghi.txt
I need to design a job so that it searches a file and puts it inside the respective folder name in the local directory.
For example, it would search "abc.txt" in remote directory, if it finds it will dump into the "abc" folder of the local directory if not it would search with the second file name. Like this it would continue.
this is one way that get all the files into some local staging directory and list those files and copy those files into specific directory by getting the filename with removing .txt. while using tfilecopy you can specify that create a directory if not exists.
@michael_010 , you can use the tFTPGet component to get the files from remote server to local folder and if you need to get txt file from server you need to specify "*.txt" as file mask.
this is one way that get all the files into some local staging directory and list those files and copy those files into specific directory by getting the filename with removing .txt. while using tfilecopy you can specify that create a directory if not exists.
