Secure FTP using Windows batch script

Question

I currently have batch scripts on different servers that transfer a csv file to an FTP server at a different location  My script looks similar to this   echo user ftp user gt  ftpcmd dat echo password gt  gt  ftpcmd dat echo put c  directory  1-export- date  csv gt  gt  ftpcmd dat echo quit gt  gt  ftpcmd dat ftp -n -s ftpcmd dat ftp MyFTPSite com del ftpcmd dat   If I wanted to require a secure transmission  is how would my script be updated   Thanks

User · Answer

ftps -a -z -e on -pfxfile  S-PID p12  -pfxpwfile  S-PID p12 pwd  -user  lt S-PID number gt  -s script  lt RemoteServerName gt  2121  S-PID p12   gt  certificate file name   S-PID p12 pwd   gt  certificate password file name    RemoteServerName   gt   abcd123    2121   gt  port number    ftps   gt  command is part of ftps client software

User · Answer

The built in FTP command doesn t have a facility for security  Use cUrl instead  It s scriptable  far more robust and has FTP security

User · Answer

First  make sure you understand  if you need to use Secure FTP   FTPS  as per your text  or SFTP  as per tag you have used    Neither is supported by Windows command-line ftp exe  As you have suggested  you can use WinSCP  It supports both FTPS and SFTP   Using WinSCP  your batch file would look like  for SFTP    echo open sftp   ftp user password ftp MyFTPSite com -hostkey  server s hostkey   gt  gt  ftpcmd dat echo put c  directory  1-export- date  csv  gt  gt  ftpcmd dat echo exit  gt  gt  ftpcmd dat winscp com  script ftpcmd dat del ftpcmd dat   And the batch file   winscp com  log ftpcmd log  script ftpcmd dat  parameter  1  date      Though using all capabilities of WinSCP  particularly providing commands directly on command-line and the  TIMESTAMP  syntax   the batch file simplifies to   winscp com  log ftpcmd log  command        open sftp   ftp user password ftp MyFTPSite com -hostkey   server s hostkey           put c  directory  1-export-  TIMESTAMP yyyymmdd   csv         exit    For the purpose of -hostkey switch  see verifying the host key in script   Easier than assembling the script batch file manually is to setup and test the connection settings in WinSCP GUI and then have it generate the script or batch file for you     All you need to tweak is the source file name  use the  TIMESTAMP  syntax as shown previously  and the path to the log file     For FTPS  replace the sftp    in the open command with ftpes     explicit TLS SSL  or ftps     implicit TLS SSL   Remove the -hostkey switch   winscp com  log ftpcmd log  command        open ftps   ftp user password ftp MyFTPSite com -explicit         put c  directory  1-export-  TIMESTAMP yyyymmdd   csv         exit    You may need to add the -certificate switch  if your server s certificate is not issued by a trusted authority   Again  as with the SFTP  easier is to setup and test the connection settings in WinSCP GUI and then have it generate the script or batch file for you     See a complete conversion guide from ftp exe to WinSCP   You should also read the Guide to automating file transfers to FTP server or SFTP server     Note to using  TIMESTAMP yyyymmdd  instead of  date   A format of  date  variable value is locale-specific  So make sure you test the script on the same locale you are actually going to use the script on  For example on my Czech locale the  date  resolves to ct 06  11  2014  what might be problematic when used as a part of a file name   For this reason WinSCP supports  locale-neutral  timestamp formatting natively  For example  TIMESTAMP yyyymmdd  resolves to 20170515 on any locale    I m the author of WinSCP

[windows] Secure FTP using Windows batch script

Examples related to windows

Examples related to batch-file

Examples related to ftp

Examples related to sftp