I have detailed my requirement below and please assist me here.
I need to copy .CSV File from a Windows Server shared path (\\hostname\output) to another server which is on unix.
I will have to use SFTP and not FTP.
I'm sure its probably possible using some clever plsql (or c/java) to do this directly from within the database. However it may be easier to just write a batch script which calls an scp/sftp command and transfers the file. This script can easily be called by DBMS_SCHEDULER. winscp is an sftp client but I'm not sure if there is a command line version of it? if not there are plenty of other command line sftp clients - putty (psftp) for example.