SFTP, PGP and Zip Control Flow custom components
A set of custom tasks to extend SSIS. Includes a SFTP task, PGP encryption task and zip/unzip task.

Includes custom components to SFTP, Encrypt/Decrypt files using PGP and zip/unzip task for SSIS 2008 and SSIS 2012.
  • System Requirements:
    • Microsoft SQL Server 2008
    • Microsoft SQL Server 2012
    • Microsoft Visual Studio 2012
  • This project can also help people figure out how to code a Custom SSIS Task using a Custom UI and Property Grid.

Note: I'd appreciate any feedback on the project, also let me know if you'd like more components.

Change Log
  • May 19, 2013
    • Unified installer for SQL 2008R2 and 2012, both 32-bit and 64-bit
    • Fixed issue with dll mismatch
  • Feb 16, 2013
    • Uploaded the updated SQL 2008 R2 project
    • Uploaded sample and documentation for SQL 2008 R2 project
    • Comming soon - FTP component.
  • Feb 9, 2013
    • Fixed a few bugs
    • Added filtering ability to Zip task as well as SFTP task
    • Coming soon - move changes to SQL 2008 R2 project.
  • July 31, 2011
    • Added Zip Task
    • Added support for wildcards.
    • Fixed: bug in SFTP task during validation.
    • Fixed: getting error in SFTP task when receiving no files.

Last edited May 20, 2013 at 2:08 PM by mcpunjabi, version 19