The SSIS Library is a software tool equipped with a vast library of tasks, components, and scripts for compressing files to Zip, GZip, BZip2, and Tar archives, secure transfers, data encryption with OpenPGP, and integration with various platforms including Amazon S3, Salesforce, SharePoint, and Dynamics CRM. It also provides support for data management in Excel, email protocols IMAP, POP3, S/MIME, EDI, and ODBC bulk-loads, and data storage in Oracle, DB2, and Informix.
This amazing application integration software supports major platforms like Dynamics CRM, SharePoint, Salesforce, Dynamics AX, QuickBooks, Sage, Dynamics GP, OpenAir, NetSuite, SugarCRM, and Dynamics NAV. It also has capabilities for secure file transfer using SSH, FTPS, SCP, SSH shell commands, and secure tunnels.
With its file compression capability, this software can easily compress files and archives using Zip, GZip, BZip2, Unix, and Tar formats. Additionally, it has an extended scripting feature for better reuse and an extended data flow task for dynamic and reusable data flows.
This program also makes it easy to manage SQL server partitions, and it employs encryption with OpenPGP standard for encryption, decryption, signing and signature verification. You can also use it to send, receive, delete and list files with Amazon S3, and communicate bi-directionally with Jabber clients.
The software streamlines the management of standard objects, generates arbitrary documents based on templates, and transforms EDI files into a tabular format at incredible speeds. It also supports fast bulk-load for Oracle, DB2, Teradata, MySQL, Informix, Vertica, Sybase, and ODBC databases.
The USPS address validation feature lets you split addresses into separate components while verifying against the USPS reference database. Look-up has also been simplified to enhance its transformation feature, while the table difference functionality lets you compare two tables to identify the differences.
With its data flow link feature, you can easily transfer data between data flows in no time, and its package connection feature provides real-time access to package objects. You can also use the advanced email functionality to send and receive emails using IMAP, Exchange, POP3, SMTP, and S/MIME protocols.
The software also boasts of advanced Excel integration, supporting both 32bit and 64bit execution. Additional features include the Parallel Loop Task, which lets you concurrently execute Foreach Loops, Query Transformation, for one or more lookup rows retrieval, and Tableau Destination for the generation of Tableau TDE files.
Version 1.6: N/A
Version 1.5: N/A
Version 1.4: N/A
Version 1.2: N/A