• itmasterw 60042 - Wednesday, February 28, 2018 1:41 PM

    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/