Scripting Secure FTP to PUT File on Remote Server

• mickielsmith

  Right there with Babe

  Points: 723

  More actions

  October 29, 2010 at 9:44 am

  #145999

  Hello All,

  I have a scripting problem here. I am tasked with creating a SQL Sever Job and the Job Step is to create a script to emulate the MS-DOS CMD.

  I want to do an Secure FTP task via the SQL Server Job. I have the Job Step Properties as follows:

  Step Name: Job Step Name

  Type: Operating System (CmdExec)

  Run as: SQL Agent Service Account

  Command: !--Comment -- This is the part that is stumping me, because the script now only has to open the secure FTP application. It has to pass the parameters. I wanted to have confidential informtion like the username and password in a file that can be called from this script along with rest of FTP command like lcd, cd PUT, disconnect, bye. I have a secure FTP application called WinSCP. I just need the correct script syntax or example to complete this. Can anyone help?

  This is the current command I have:

  "C:\Program Files\WinSCP\WinSCP.com" "open" "username@domain" -pw password -P port -b filename.txt