Sunday, March 11, 2012

Can SSIS do SFTP? and how?

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

Thanks,

Kev

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.|||

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

|||We have recently released SFTP SSIS task for secure communications. It has user interface and functionality very similar to the standard FTP task. You may check it here: http://www.cozyroc.com/products.html

Regards,
Ivan

No comments:

Post a Comment