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:
Secure File Transfer - Support for SSH, FTPS and SCP protocols. Support for secure execution of shell commands on a remote SSH server. Support for secure tunnels.
File Compression - Zip, GZip, BZip2, Unix, Tar archives.
Enhanced Scripts - extended scripting technology for better reuse.
Extended data flow - 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 - Support Oracle, DB2, Informix, 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.
Salesforce Integration - Reading and writing of Salesforce objects.
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, POP3, SMTP, S/MIME.
Excel Integration - Advanced integration with Microsoft Excel workbooks. Support for 64bit execution.
Parallel Loop Task - Concurrent Foreach Loop execute.
Dynamics CRM Integration - Reading and writing of Dynamics CRM entity.
SharePoint Integration - Reading and writing of SharePoint list.
