Topic "SSIS and Winscp"

Author Message
Guest




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.
LogScript.txt (5 KB) [Download]

Description: (none)

LogCommandLine.txt (4.98 KB) [Download]

Description: (none)

martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25034
Location: Prague, Czechia
Please read FAQ:
https://winscp.net/eng/docs/faq_scheduler

If that does not help, come back.
_________________
Martin Prikryl
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License