Skip to Content


Feb 27 at 10:57 AM


avatar image

Hi Experts ,

I have requirement to move the file from one folder to another folder in SFTP as the file location is in another server i got user name and password of the server could you please let me know how to work on this in BODS

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ravi kiran Pagidi Feb 27 at 11:05 AM

Hi SIva,

Create a file location object under file format tab with all the details of SFTP server and use copy_from_remote_system() function in DS and give file location in function enclosed in single quotes.

or you could use file_move(), file_copy() builtin functions in DS.

Show 4 Share
10 |10000 characters needed characters left characters exceeded

HI Ravi ,

Thanks For the response .

Could you please help me how copy_from_remote_system() will help has i already created the file floder uner file formats with user name and password


This function uses information from the named file location object to copy file(s) from a remote server to a local server.

Use this function in a script to transfer an input file from a remote server into a local server to be used as a source in your data flow

Syntax:- copy_from_remote_system(“<file_location_object name>”, “<remote_file_name>”)

example:- copy_from_remote_system(“flo_ftp_1”, “prod.txt”);

This function uses the FTP information in the file location object flo_ftp_1 to copy the file named prod.txt that is located in a remote directory.


Hi ,

But with i can copy the file but i am not able to move form the SFTP one folder to another .


are you using any 3rd party scheduler tool for scheduling you jobs? if yes, then that scheduler tool will have File transfer mechanism and you can use it to transfer files.