Putty Secure SFTP occasionally stops working; what do you use?

• Lowell

  SSC Guru

  Points: 323504

  More actions

  December 24, 2014 at 7:11 am

  #299796

  what do you use for automated Secure FTP downloads? I need to get some peer review and probably change tools.

  i've got dual issues here.

  the first issue, is when there is a LOT of files on the ftp site (ie more than 512?), putty only seems to grab some, but not ALL, of the files when the mget command is passed. that can be a big problem, i need all files, every time.

  the second issue is putty intermittently just stops working.

  I've got an SSIS package that is was calling putty's psftp.exe from a command line, and occasionally, it stopped working, usually due to the registry having lost the key for the site in HKCU;

  i thought i solved that by pulling eveything out as an SQL Job Step and command prompts, where i called regedit to explicitly re-install the registry key every time, and then call the bat file, which in turn calls the psftp.exe with the approriate parameters to download any files on the ftp site.

  even with that in place, i'm having intermittent problems, so i want to throw psftp.exe out the window and start again.

  if it's relevant, my current process calls a batch, which feeds a script file with additional commands.

  here's my batch file:

  "D:\WorkingFolder\Zips\psftp.exe" NotTheRealUser@ftps2.myWebsite.com -v -batch -pw NotTheRealPassword -b "D:\WorkingFolder\Zips\download_daily.script" < "D:\WorkingFolder\Zips\SaveRSAKeyYes.script"

  exit

  and here's my download_daily.script script:

  lcd D:\WorkingFolder\Zips\

  mget *.zip

  cd ./ARCHIVE

  mput *.zip

  cd ../

  mv *.zip ./ARCHIVE

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!