Do you really have ssh-rsa 2048 xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx in your script? That's for sure not a valid host key fingerprint.

See also https://winscp.net/eng/docs/faq_hostkey#automation

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