- martin
Post a reply
Before posting, please read how to report bug or request support effectively.
Bug reports without an attached log file are usually useless.
Topic review
- Guest
SSIS and Winscp
Hi there,
I have a bit of an unusual issue when attempting to integrate winscp with SQL Server Integration Services
My preferred approach is to run the following :
WinSCP.exe /command "option batch abort" "option confirm off" "open sftp://#########:########@ftps.#####.com " "lcd \\######" "get PRD*"
"exit" -log="D:\WinSCP\Log\WinSCPCommandline.txt" -hostkey="###########"
However, this is failing with "The server's host key was not found in the cache"
What is strange though, is that when I run everything via a script, the process runs fine:
WinSCP.exe /script=D:\Data\Shell\WinSCP.txt /log=C:\Temp\WinSCPConf.txt
Contents of WinSCP.txt:
option batch abort
option confirm off
open sftp://#########:########@ftps.#####.com:22 -hostkey="###########"
lcd D:\#########
get PRD*
exit
I have included the logs from both approaches.
Please can you assist.
I have a bit of an unusual issue when attempting to integrate winscp with SQL Server Integration Services
My preferred approach is to run the following :
WinSCP.exe /command "option batch abort" "option confirm off" "open sftp://#########:########@ftps.#####.com " "lcd \\######" "get PRD*"
"exit" -log="D:\WinSCP\Log\WinSCPCommandline.txt" -hostkey="###########"
However, this is failing with "The server's host key was not found in the cache"
What is strange though, is that when I run everything via a script, the process runs fine:
WinSCP.exe /script=D:\Data\Shell\WinSCP.txt /log=C:\Temp\WinSCPConf.txt
Contents of WinSCP.txt:
option batch abort
option confirm off
open sftp://#########:########@ftps.#####.com:22 -hostkey="###########"
lcd D:\#########
get PRD*
exit
I have included the logs from both approaches.
Please can you assist.