SSIS+ includes components and scripts for handling Zip, GZip, BZip2, Tar archives enhanced script reuse and secure internet communications and a library for SSIS tasks.
This is the current list of components:
· Script Component Plus – Extends Microsoft Script component for greater usability and maintenance.
· Template Task – Generation of arbitrary text documents.
· Data Flow Task Plus – Dynamic data flows.
· Address Parse – US Postal Address parse and correction.
· ODBC Destination – Regular and bulk-load of data in ODBC table.
· SCP Task – Secure copying of files.
· Lookup Plus – Simplified and enhanced lookup transformation.
· Salesforce Source – Load data from Salesforce service.
· Salesforce Destination – Store data to Salesforce service.
· Salesforce Connection Manager – Connections with Salesforce service.
Requirements:
· Windows SQL Server SSIS 2005
What's New in This Release: [ read full changelog ]
· Implemented Data Flow Destination support a variable used to signal a waiting thread, data processing has finished.
· Various fixes in the SSH back-end component.
· Implemented SFTP task Get remote files list action to provide extended remote file information.
· Implemented option in SFTP task to specify if remote path is a wildcard or not.
· Fixed SFTP task to provide cleaner errors description.