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

  • New: Support for SQL 2014.
  • New: Tableau Destination component.
  • Fixed: Zip Task created packages with AES encryption which failed to decrypt with newer versions of WinZip and 7-Zip (Thank you, Barry).
  • Fixed: Data Flow Task Plus used in combination with Parallel Loop Task failed when used with Flat File Source or Destination components (Thank you, Dan Palazotto).
  • Fixed: NetSuite Destination component failed to delete records from custom record type (Thank you, Mark).
  • Fixed: Receive Mail Task failed to process email containing attachments with invalid date metadata (Thank you, Aaron).
  • New: A new parameter Mode in Salesforce Source component with two options: Regular and Bulk. When bulk mode is used, the component will use Salesforce bulk read functionality.
  • Fixed: Amazon S3 Task failed with error "Index was out of range. Must be non-negative and less than the size of the collection." (Thank you, Carl).
  • New: A new parameter Passphrase in SSH Connection Manager.
  • New: Dynamics AX adapters now support Dynamics AX 2012 derived tables (Thank you, Tom).
  • New: A new parameter AssociationCustom in OpenAir Source component. IncludeCustom parameter is deprecated.
  • New: A new parameter AssociationCustom in OpenAir Destination component.
  • New: QuickBooks adapters now support QuickBooks Online Data Services.
  • Fixed: ODBC Destination component failed to process in 64bit mode.
  • Fixed: Zip Task failed with error "Cannot access a closed file" when trying to create Tar archive without compression (Thank you, David).
  • New: QuickBooks adapters now support DataExt object.
  • Fixed: Data Flow Task Plus failed when using Fuzzy Lookup transformation (Thank you, Matt).
  • Fixed: QuickBooks Source component failed with error "Object reference not set to an instance of an object" when trying to use TxnDeleted object (Thank you, Richard).
  • New: A new 'Get cell' action in Excel Task.
  • New: A new 'Set cell' action in Excel Task.
  • New: A new parameter ServerFingerprint in SSH Connection Manager to verify remote host fingerprint before authentication.
  • New: A new parameter OrganizationId in Salesforce Connection Manager.
  • New: A new parameter PortalId in Salesforce Connection Manager.
  • New: A new parameter Concurrency in Salesforce Destination component with two options: Parallel and Serial.
  • Fixed: NetSuite Source component failed when using saved search against custom record (Thank you, Mark).
  • Fixed: Dynamics GP Source component returned only first 1000 records (Thank you, Patricia).
  • Fixed: NetSuite Source component failed with error "The maximum number (1000) of records allowed for a READ operation has been exceeded" when having more than 1000 customizations (Thank you, Sam).
  • Fixed: NetSuite's pricingMatrix composite object was not available for use (Thank you, Rahim).
  • Fixed: Teradata Destination component failed when using column of type ByteInt (Thank you, Alan).
  • Fixed: Data Flow Task Plus failed when Lookup Plus transformation had more than one lookup definition against same input column (Thank you, Fabien).
  • New: A new parameter Attributes in OpenAir Source component.
  • Fixed: Numerous fixes and enhancements in the Dynamics GP adapters (Thank you, Patricia).
  • Fixed: Query component failed when input lookup parameter was NULL (Thank you, Don).
  • Fixed: Excel Destination component failed when multiple instances executed simultaneously against same connection (Thank you, Manasi).
  • Fixed: Parallel Loop Task failed under SQL 2012 with error "A deadlock was detected while trying to lock variables "..." for read/write access. A lock cannot be acquired after 16 attempts. The locks timed out." when Project parameters were defined (Thank you, Ecki).