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

Check CozyRoc SFTP task for secure communications. It has user interface and functionality very similar to the standard FTP task.Regards,Ivan

Hi,you could try:1) CodeProject: SFTP with SSIS Packages (free, scripts external WinSCP tool) or2) Rebex SFTP for .NET (commercial). Here is help on registering the dll for work with the SSIS.Martin

How did you register the Xceed componentit so it shows up in the script task?

Seeing that many people are trying to use WinSCP to implement SSIS SFTP transfer task, I have prepared a guide to SFTP Task for SSIS .

nSoftware provides the solution and is pretty easy to implement.

There are some Free components in Task Factory... try it ... they also have Secure FTP (SFTP and FTPS both)http://www.pragmaticworks.com/Products/Business-Intelligence/TaskFactory/

There are some Free components in Task Factory... try it ... they also have Secure FTP (SFTP and FTPS both) http://www.pragmaticworks.com/Products/Business-Intelligence/TaskFactory/ SSIS-Tutorials-FAQs | Convert DTS to SSIS | Document Entire BI | SSIS Tasks | BIDS Plugin

Without component :http://www.xoowiki.com/Article/SQL-Server/ssis-acces-sftp-475.aspx

If you're looking for a free solution, we're using FTP Task++ from http://www.easkills.com/ssis/ftptask

Yes, you can. This SFTP Component (more info can be found on this ComponentSoft SFTP's blog )can be used in SSIS. You just need to reference to its DLLs and do you work normally.

hi i looked at your code but didnt find the Ftp component in .net. can you please upload the custom Ftp.dll to your blog so i can use your script.

Take a look at SFTP Task for SSIS in our BizCrypto product.

Take a look at the following topics for the Ultimate SFTP component: - How to use SFTP component in the SSIS package - Using the SFTP component in PowerShell