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.