SSIS Job fails - Host key does not match configured key
Hello,
I am using a command line in Execute Process Task in SSIS that runs successfully manually in the BIDS but fails when run it from SQL Server Jobs with an error in the log of "Host key does not match configured key". Any help you could provide would be greatly appreciated.
Below are my settings in the ssis task...
Executable:
C:\Program Files (x86)\WinSCP\WinSCP.exe
Arguments:
/command "option batch abort" "option confirm off" "open sftp://xxxxxx:xxxxxxx@server.com:22 -implicit -hostkey=""
ssh-rsa 2048 xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx""" "put C:\Projects\ABC\DataFileOutput\* /Data/Test_files/" "exit" /log="C:\Projects\ABC\ABCData.log" /loglevel=0 /defaults /console /rawsettings
I am using a command line in Execute Process Task in SSIS that runs successfully manually in the BIDS but fails when run it from SQL Server Jobs with an error in the log of "Host key does not match configured key". Any help you could provide would be greatly appreciated.
Below are my settings in the ssis task...
Executable:
C:\Program Files (x86)\WinSCP\WinSCP.exe
Arguments:
/command "option batch abort" "option confirm off" "open sftp://xxxxxx:xxxxxxx@server.com:22 -implicit -hostkey=""
ssh-rsa 2048 xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx""" "put C:\Projects\ABC\DataFileOutput\* /Data/Test_files/" "exit" /log="C:\Projects\ABC\ABCData.log" /loglevel=0 /defaults /console /rawsettings
