SSIS+ 1.6
ibrary 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.
