Hi,
I have been looking all over the web for this. I realize that SSIS does not, on its own handle SFTP. A number of sites suggest using WinSCP, but have not gives a full explanation of how to code for this. Maybe its me but they seem to leave things out. Like one site did that I need a FingerPrint variable, but did not explain what the was; I found that out on another site, but then that left out other things.
Does anyone know of a good site for this or maybe you might have a better way; I sure would be open to anything at this point.
Thank you
Why can't you read this first ?
https://www.mssqltips.com/sqlservertip/3435/using-sftp-with-sql-server-integration-services/