This project is read-only.


SFTP Task (SSIS Control Flow Custom Component)

 *A beta version for use within SSDT 2014 is available here


As the name says it, this custom  "Control Flow" component can be used to send/receive files via a SFTP Connection.

  • System requirements:
    • Microsoft SQL Server 2012 - for SSIS development 
    • Microsoft Visual Studio 2012/2013 - for component development

Please take a look at the documentation page to see how you can use it.


Supporting "SSIS SFTP Task Control Flow Component"

If you use the SFTP component to support your own or your organization's software development, please consider making a monetary donation to the library author. Your donation will help support the continued development of SSIS SFTP Component.

Some very important remarks: this component is based on the SharpSSH (ver. library developed by Tamir Gal.

As he specify on the home page of his library, the actual SFTP component that I made, may be summarized as follows:
  • SharpSSH is pure .NET, but it depends on Crypto Library for encryption and integrity functions.
  • SSH2 protocol support
  • SSH File Transfer Protocol (SFTP)
  • Secure Copy (SCP)
  • Key exchange: diffie-hellman-group-exchange-sha1, diffie-hellman-group1-sha1
  • Cipher: 3des-cbc, aes128-cbc
  • MAC: hmac-md5
  • Host key type: ssh-rsa, ssh-dss
  • Userauth: password, private key (RSA, DSA) - only OpenSSH version is supported
  • Port Forwarding
  • Stream Forwarding
  • Remote Exec
  • Generating DSA and RSA key pairs
  • Changing the passphrase for a private key

So here we are. I've done minimal cleanup, and the code isn't perfect (and there are few comments) but I could not find anything similar online for free and I thought the best thing to do would be to share the code today instead of waiting to polish it before sharing it.

The initial public release is online so everyone should be able to download the code to use (and tweak) on their own.

Note: I'd really appreciate any feedback on whether you think the project isn't feasible, whether you'd like to use it if it were more mature, and that sort of thing. 

Last edited Nov 5, 2016 at 8:02 PM by cosminfr, version 17