Hi

I've got some SSIS packages running that regularly take files from an FTP site and upload them to a SQL2008 database.

A couple of the FTP sites are moving to SFTP and the FTP component in SSIS doesn't handle that.

Has anyone got a recommended way of setting up a transfer from a SFTP site.

Thanks