SSIS+

Library of SSIS tasks, components and scripts for handling Zip, GZip, BZip2, Tar archives, enhanced script reuse and secure internet communications. This is the current list of technology:

Application Integration - Dynamics CRM, SharePoint, Salesforce, Dynamics AX, QuickBooks, Sage, Dynamics GP, OpenAir, NetSuite, SugarCRM, Dynamics NAV

Secure File Transfer - SSH, FTPS, SCP, SSH shell commands, secure tunnels.

File Compression - Zip, GZip, BZip2, Unix, Tar archives.

Enhanced Scripts - extended scripting technology for better reuse.

Extended Data Flow Task - dynamic and reusable data flows.

SQL Server Partitions - simplified database partitions management.

Encryption with OpenPGP standard - encryption, decryption, signing and signature verification.

Amazon S3 - send, receive, delete and list files.

Jabber - bi-directional communication with Jabber clients.

Stream - Management of standard Stream objects.

Template Document Generation - in-memory streaming generation of arbitrary documents based on template.

EDI Files - Very fast transformation of EDI files to tabular format.

Fast bulk-load - Oracle, DB2, Teradata, MySQL, Informix, Vertica, Sybase, ODBC databases.

USPS Address Validation - Can split address into separate components. An optional support for verification in USPS reference database.

Lookup Plus - Simplified and enhanced lookup transformation.

Table Difference - Compare two tables to find differences.

Data Flow Link - Very fast in-memory data transfer between data flows.

Package Connection - Get access to package object at runtime.

Advanced Email - Advanced email send and receive. Support IMAP, Exchange, POP3, SMTP, S/MIME.

Excel Integration - Advanced support for Microsoft Excel. Also support 64bit execution.

Parallel Loop Task - Concurrent Foreach Loop execute.

Query Transformation - One or more lookup rows retrieve.

Tableau Destination - Generation of Tableau TDE files.