I am FTPing files by invoking batch script through Data Stage, I am able to capture all the commands that i have placed in the batch script but not able to get the remote server response like "226 Transfer complete" . Any idea how to capture it through data stage.
cmd = "ftp -i -d -s:U:\DataStageProd\ndw\jobcontrol\batchscripts\VIP_Ftp.parm >> U:\DataStageProd\ndw\work\staging\VIP_Log\VIPLOG"
CALL DSExecute("NT", cmd, ScreenOutput, SystemReturnCode)
Thanks
How to capture remote server response during FTP
Moderators: chulett, rschirm, roy
Yes and nothing is there in ScreenOutput Variable -
cmd = "ftp -i -d -s:U:\DataStageProd\ndw\jobcontrol\batchscripts\VIP_Ftp.parm >> U:\DataStageProd\ndw\work\staging\VIP_Log\VIPLOG"
*----------------------------------------------------------
CALL DSExecute("NT", cmd, ScreenOutput, SystemReturnCode)
*----------------------------------------------------------
CALL DSLogInfo("SQL CMD = ":cmd,"Command")
CALL DSLogInfo("Screenoutput = ":ScreenOutput,"INFO")
CALL DSLogInfo(SystemReturnCode,"INFO")
O/P
VIPWrapper.60.JobControl (INFO): Screenoutput =
cmd = "ftp -i -d -s:U:\DataStageProd\ndw\jobcontrol\batchscripts\VIP_Ftp.parm >> U:\DataStageProd\ndw\work\staging\VIP_Log\VIPLOG"
*----------------------------------------------------------
CALL DSExecute("NT", cmd, ScreenOutput, SystemReturnCode)
*----------------------------------------------------------
CALL DSLogInfo("SQL CMD = ":cmd,"Command")
CALL DSLogInfo("Screenoutput = ":ScreenOutput,"INFO")
CALL DSLogInfo(SystemReturnCode,"INFO")
O/P
VIPWrapper.60.JobControl (INFO): Screenoutput =