Can SSIS do SFTP? and how?

I want to know whether SSIS can do SFTP. If yes, how does it work

Thanks,

Kev

Martin Lundberg
Yes

We are using Xceed FTP component in a Script Task (http://xceed.com/FTP_NET_Features.html)

Certain operations (zip, ftp, email) in SSIS are not built-in or doesn't suffice the requirements in which case you can extend the functionality using components, script tasks or custom-built tasks.
emmmmmmer
Check CozyRoc SFTP task for secure communications. It has user interface and functionality very similar to the standard FTP task.

Regards,
Ivan
Maheshsingh21

TPK1216 wrote:

I want to know whether SSIS can do SFTP. If yes, how does it work

Thanks,

Kev

nSoftware have a suite of SSIS tasks, one of which is an SFTP task.

More here:

nSoftware releases IPWorks for SSIS
(http://blogs.conchango.com/jamiethomson/archive/2006/06/02/SSIS_3A00_-nSoftware-releases-IPWorks-for-SSIS.aspx)

-Jamie
Can SSIS do SFTP? and how?