Post a reply

Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)


Topic review


SSIS Job fails - Host key does not match configured key

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...

C:\Program Files (x86)\WinSCP\WinSCP.exe

/command "option batch abort" "option confirm off" "open s -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