I am trying to run pscp.exe from my vb script task and run it from an SQL job but it looks like there is a security warning waiting for a click on the server side. Anyone running pscp.exe from script task with success?
.StartInfo.UseShellExecute = True
.StartInfo.Arguments = "\\BLMCIK\CMAMS\pscp.exe -l report -pw report " & RawData(i).ToString & " " & TreatedData(i).ToString
.StartInfo.FileName = ArgumentLine
.StartInfo.WindowStyle = ProcessWindowStyle.Hidden