Executing winscp as a process task in ssis. task executes nor error but files are not brought down

Advertisement

bobghw
Guest

Executing winscp as a process task in ssis. task executes nor error but files are not brought down

as title says task executes but no files brought down.

using

option batch abort
option confirm off
open sftp:xxxxxx:*xxxxxxx@10.xxx.xxx.xxx :22
get /Pickup Linkage files from MoH/*.txt C:\Test
exit

the hostname, username and password are correct as tested in filezilla

the execute process task in ssis

Executable C:\Program Files (x86)\WinSCP\WinSCP.exe
Arguments -script=C:\WinscpLINKScript.txt
Working Dir C:\Program Files (x86)\WinSCP

Reply with quote

Advertisement

bobghw
Guest

edit

I found some spaces in my script and sorted those, and changed the .exe to .com
and tested in cmd window.

I now get error below but "XXXXX_NHI_Link" is not the host it is the user

batch abort
reconnecttime 120
confirm off
Searching for host...
Host "XXXXX_NHI_Link" does not exist.

open sftp://XXXXX_NHI_Link:xxxxxx@10.xx.xxx.xxx:22

Reply with quote

martin
Site Admin
martin avatar
Joined:
Posts:
41,518
Location:
Prague, Czechia

Re: Executing winscp as a process task in ssis. task executes nor error but files are not brought down

Please attach a full log file showing the problem (using the latest version of WinSCP).

To generate log file, use /log=path_to_log_file command-line argument. Submit the log with your post as an attachment. Note that passwords and passphrases not stored in the log. You may want to remove other data you consider sensitive though, such as host names, IP addresses, account names or file names (unless they are relevant to the problem). If you do not want to post the log publicly, you can mark the attachment as private.

Reply with quote

Advertisement

You can post new topics in this forum