Tuesday, May 3, 2011 - 11:58
Released CozyRoc SSIS+ 1.5 SR-2 (1.5.102.0). The release includes the following major changes:
- New: SAS® Data Source component for retrieving data from sas7bdat files.
- New: SAS® Data Destination component for writing data into sas7bdat files.
- Fixed: ODBC Destination component failed with "String cannot be of zero length. Parameter name: oldValue" error when destination database is IBM Informix Dynamic Server.
- Fixed: Advanced Excel integration adapters are now multithread-safe.
- New: SFTP Task now reports bytes transferred, when sending/receiving files (Thank you, John).
- New: A new option NoAuthentication in SMTP Connection Manager.
- New: Lookup Plus component now uses multi-threaded lookups loading.
- Fixed: Dynamics CRM Connection Manager was not able to connect to hosted CRM service (Thank you, Joao).
- Fixed: Improved Table Difference component setup dialog loading speed, when using many columns.
- Fixed: SharePoint Destination component inserted incomplete date columns.
- Fixed: SSH Connection Manager failed with "Cannot access a disposed object." error when using new backend engine.
- New: A new option LocalFilter in SFTP Task to set local file filter expression when using 'Send files' action.
- New: SharePoint Source component now includes column with list item's attachments (Thank you, Anthony).
- New: Excel Source Plus component now supports named ranges.
- Fixed: Database Partitions Task failed to process tables with foreign keys, which reference multiple columns (Thank you, Sergio).
- New: Data Flow Task Plus now includes more options for processing flat files.
- New: A new option CreatePrimaryKeys in Database Partitions Task to create primary keys when using 'Create Partition' action.
- New: A new option IncludeHidden in SharePoint Source component to include list's hidden fields.
- New: SFTP Task now supports move of multiple files, when using 'Rename remote file' action (Thank you, Richard).
- New: A new option MissingColumnFail in Data Flow Task Plus for dynamic destination components. When set, the task will fail if source column is missing in destination.
- Fixed: Data Flow Task Plus setup dialog was not opening properly, when package was in a solution with multiple SSIS projects (Thank you, Anthony).
- Fixed: Dynamics CRM Source component failed when certain FetchXML statements were specified (Thank you, Jamal).
- New: Database Partitions Task now supports SQL 2008 table compression option.
- New: Dynamics CRM Source component can now retrieve data from StringMap and ListMember entities.
- Fixed: Salesforce Source component failed with “INVALID_TYPE: sObject type ‘…’ is not supported.” error when processing certain SOQL statements containing relationships (Thank you, Jonlee).
- Fixed: Dynamics CRM Destination component failed to process input columns of type DT_NTEXT.
- Fixed: Address Parse component is now multithread-safe.
- New: Dynamics CRM Destination component now supports adding and removing records in ListMember entity.
- New: Dynamics CRM Destination component now supports update of more entity attributes.
- New: Dynamics CRM integration adapters now provide better error diagnostic information.
- New: Oracle Destination component is no longer dependent on specific version of Oracle Data Provider for .NET.
- New: DB2 Destination component is no longer dependent on specific version of IBM DB2 .NET Data Provider.
- New: Informix Destination component is no longer dependent on specific version of IBM Informix .NET Data Provider.
- Fixed: Salesforce Destination component failed with "Column data type is not supported by PipelineBuffer class." error when processing input columns of type DT_DBDATE (Thank you, Ellen).
- New: New API methods in IMAP Connection Manager.
- New: Zip Task can now encrypt and decrypt AES encrypted files.
- Fixed: Parallel Loop Task didn't update package-scoped variables used in the loop.
- Fixed: FTPS Connection Manager failed with "Already logged in (530)" error when connecting to certain servers with client certificate (Thank you, Ulia).
- New: A new option ObjectFilter in Salesforce Source component.
- New: Dynamics AX Destination component now uses optimized bulk-data insert.
- New: Dynamics CRM Connection Manager now supports CRM Live deployment in EMEA and Asia.
- Fixed: SSH Connection Manager failed with "Bad Message" error when using Serv-U server and Remote parameter contained wildcard.
- New: Salesforce Destination component can now update foreign key lookups with external identifier.