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
Did you check the documentation on WinSCP's site? You may want to read their documentation -
SFTP Task for SSIS
There are quite a few posts with examples on using WinSCP. The best thing to do is start trying to use it following those examples. Here is a basic example:
SFTP with SSIS Packages
Sue