BODS- Move file from SFTP to local

[Former Member]

I am using copy_from_remote_system function in BODS to get files from SFTP server. As we can't provide destination , it take a predefined destination and put the files there. How to move File from SFTP server to specific location.

PS : This process should be done in one step. We can not take the file in predefined location first and then move again.

[former_member316405]

Create a file location object under file format tab with all the details of SFTP server. Give the file location object name in copy_from_remote_system function enclosed in single quotes.

Thanks,

Niranjan