Hello Gurus,

Help needed to transfer list of files to FTP server, to different folders

My requirement is something like this

I want to create a concurrenct program in Oracle Applications using shell script to transfer files from Apps Server to destination FTP server.

I have created custom program where I will extract all the mapping details like file_names, source_path and destination_path directories and storing in a database table.
The shell script should take the file_name and transfer the file from source_path (Apps Server) to destination path (FTP server). Since the count will be around 5000 for each run I think it will not a good idea to open FTP connection for each file transfer.

Appreciate If you can suggest the pseudo code (or) please send me any sample codes

Thanks in advance

Syed

Hi -

What you're asking can certainly be done.

But you might wish to consider an alternative like rsync:

http://everythinglinux.org/rsync/

You're aware that you can transfer multiple files in a single FTP connection, I assume. And "5000" really isn't that much. Even a relatively inefficient transfer method probably wouldn't put much of a burden either on the system or on your batch program.

IMHO .. PSM