[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2033
  • Last Modified:

PSFTP - How Do I Detect Successful Transfer from Output File?

I have a Windows batch script (attached - UFASR03_Name_302_ftpput.bat) which PSFTP's a file to a host SFTP site.  In the batch script, I reference a batch file (attached - UFASR03_Name_302_ftpput.txt) of SFTP commands and I direct the output to a text file (attached - UFASR03_Name_302_ftpput_output.txt).  I need to report back the success or failure of the transmission to the scheduling system that initiated the batch job.  

What can I use in the output file to detect a successful transmission?  The string that I use to detect a successful transmission should only appear in the output file when the transmission is successful; never should it appear if the file was not transmitted properly.

With regular FTP, I can use the following:  findstr /c:"226 Transfer" %output%
But I can't use that "226 Transfer" string with SFTP.  It doesn't appear in the output.

As you can see from the attached output file (named UFASR03_Name_302_ftpput_output.txt), there is a string as follows:  

local:JohnDoe_201008.csv => remote:/incoming/JohnDoe_201008.csv

I believe this means the file was successfully transferred.  Can I use "=> remote" as a string to reliably indicate successful transmission 100% of the time?  Will this string ever appear if there's an error?  If not, what string should I use to detect successful transmission?
0
DoubleStroke
Asked:
DoubleStroke
  • 3
  • 3
1 Solution
 
DoubleStrokeAuthor Commented:
Oops.  Here are the files.  Windows batch file is called UFASR03_Name_302_ftpput_batch.txt
UFASR03-Name-302-ftpput-batch.txt
0
 
DoubleStrokeAuthor Commented:
0
 
torimarCommented:
There seems to be no way for this in PSFTP, at least no documented one.

But PSCP will also try to use the SFTP protocol if possible, and you may even force it to do so by using the -sftp switch.
Unlike PSFTP, PSCP comes with a return value for successful transfers; please check "5.2.3 Return value" here:
http://the.earth.li/~sgtatham/putty/0.60/htmldoc/Chapter5.html#pscp
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
torimarCommented:
ps:

Also check "5.2.2.6 -sftp, -scp force use of particular protocol" right above the section quoted in my last comment.
0
 
DoubleStrokeAuthor Commented:
Torimar, I appreciate the advise but I need to use psftp.  Thank you.
0
 
torimarCommented:
DoubleStroke,

in your closing request you state that "no other solutions were helpful".

Please bear in mind that if the set task is impossible, there can be no helpful solutions.
Should you have found a way to do this with PSFTP, please let me know, I'd be eager to learn.
If, however, as I would expect, you haven't found a way to do this with PSFTP, neither referenced here nor elsewhere, allow me to remind you of the written rule on Experts-Exchange that sometimes the correct answer to a question is: "You can't do that." (http://www.experts-exchange.com/help.jsp#hs=29&hi=405 )

In the latter case, my comment above (ID:33468060) gave the correct answer (that there is no way to do this in PSFTP) as well as a workaround.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now