Released COZYROC SSIS+ 1.6 SR-2 (1.6.102.0). The release includes the following major changes:

  • New: A new parameter MultipleMatch in Dynamics CRM Destination component for use with Upsert action. The choices are: UpdateFirst, UpdateNone, UpdateAll, Fail.
  • New: A new parameter IgnoreUnchanged in Dynamics CRM Destination component to avoid updating entity attributes where the input values match the current values.
  • Fixed: Dynamics CRM Connection Manager failed with error "Security Support Provider Interface (SSPI) authentication failed." when trying to connect to CRM 2011 on premise server using Windows authentication.
  • New: A new parameter BatchMode in ODBC Destination component. The choices are: BulkOperations, ArrayParameter.
  • New: Salesforce Destination component now permits use of identifier lookup fields for the Upsert action.
  • Fixed: Dynamics CRM Destination component failed with error "String was not recognized as a valid Boolean" when trying to process boolean attributes input data set to 1 (Thank you, Srivenkata).
  • Fixed: QuickBooks Destination component failed to process input data containing diacritic characters. The issue is related to QuickBooks Desktop, which can only process ASCII characters. (Thank you, Richard).
  • Fixed: Dynamics CRM Destination component didn't include owneridtype attribute for update.
  • Fixed: Dynamics AX Source component failed with error "Value cannot be null" (Thank you, Frederic).
  • Fixed: Dynamic data flows using Derived or Conditional Split transformations failed when used with flat file input data without headers.
  • New: A new parameter "Inactive sessions close" in QuickBooks Desktop Edition Gateway to close sessions after specified time of inactivity.
  • Fixed: OpenAir Source component failed to retrieve custom fields for Costcenter type (Thank you, Tas).
  • Fixed: Dynamics AX Destination component failed with error "Cannot call NEXT, update(), or delete() on buffer where data is selected or inserted in another transaction scope" when updating certain tables (Thank you, David).
  • Fixed: Excel Source Plus component failed with error "The type initializer for '#c.#rnf' threw an exception." when reading certain files (Thank you, Scott).
  • New: A new 'Setup virtual file' action in Stream Task to setup virtual in-memory files for use with the standard Flat File and Excel adapters.
  • New: A new parameter ClearDataChannel in FTPS Connection Manager to specify if data channel is secured (encrypted).
  • New: SharePoint Connection Manager now supports Office 365 deployed systems with Federated (delegated) security (Thank you, Phil).
  • Fixed: Excel Destination Plus component UI didn't handle correctly output column modification (Thank you, Daniel).
  • New: Support for SQL Server Data Tools (aka VS 2012).
  • Fixed: Excel Destination Plus component failed to process when used in dynamic data flow (Thank you, Dan).
  • Fixed: Zip Task failed with error "CRC mismatch" when processing certain packages containing stored-only files (Thank you, Eric).
  • Fixed: Excel Source Plus failed to process sheet with name containing white space at start or end (Thank you, John).
  • New: NetSuite Source component now supports saved searches.
  • Fixed: Salesforce Destination component failed with error "The remote name could not be resolved" when using bulk-load mode with test service instances.