Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stan Kulp SFTP, encrypt or compress data files in SSIS using custom components RE: SFTP, encrypt or compress data files in SSIS using custom components

  • March 13, 2014 at 6:37 am

    #1696736

    jbuchan (3/13/2014)

    I have just completed a project on this myself but I hadn't used those components as I didn't know about them at the time.

    I used WinSCP automation

    http://winscp.net/eng/docs/library_install

    and Bouncy castle decryption runtime

    http://www.bouncycastle.org/csharp/

    I then had it all in script tasks

    I wrote an article a while back on SFTP using puTTY from a script task.

    http://www.sqlservercentral.com/Contributions/Edit/69931

    It works, but I found its reliability to be wanting. Popping up a command console in the middle of executing an SSIS package just doesn't seem to work as well as it should. I found it was failing about one time out of ten. That's when I started looking for a replacement and stumbled upon this set of extensions.