COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 1.9 library. We are very excited about the possibilities this new version provides to our customers for easier connectivity to any REST service. The other major highlight of the 1.9 release is the support for JavaScript scripting, which can dramatically simplify the implementation of custom parts in a solution by enabling a rapid development of reusable, easily-configurable components and tasks.

Those new capabilities, not available in any other product on the market, further increase the value of our SSIS+ suite, which is well-known for bringing major innovations to SSIS customers with the support of dynamic data flows, composite records modelling, etc. By choosing COZYROC SSIS+ 1.9 you can rest assured you are purchasing the most advanced technology on the market for solving even the most challenging problems in your integration projects. And the best part is that we still offer the most affordable subscription for a fully-fledged SSIS suite of tasks and components. Cheers!

We have two announcements to make:

  • Support for SQL Server 2005 and 2008 is still included. The support for these older SQL Server versions is planned for removal in the next major version. Please note the 2008 binaries now target .NET Framework 3.5 instead of .NET 2.0.
  • The cost of the SSIS+ 1.9 perpetual license has been increased to $4,999 per license.


Summary of the products available immediately for purchase:

  • SSIS+ Ultimate Subscription at $699/Year.
  • SSIS+ 1.9 perpetual license at $4,999
  • SAS® Adapters license at $2,499.95
  • USPS Address Database / One time purchase at $299.95
  • USPS Address Database / Monthly Subscription at $2,399.95/Year
  • SSIS+ Premium Support at $499.95/Year

For more information, check the purchase page.

Summary of the new / updated components

  • New: Support for SQL Server 2019.
  • New: Support for SSDT for Visual Studio 2019.
  • Improved: High-DPI scaling for high-resolution monitors.
Asana Connection
  • Fixed: Incorrect identifier field definition (Thank you, Stan).
Data Flow Task Plus
  • New: Flat File Source component will now use configured THUNK_COLUMN column length as default for all dynamic columns.
  • New: Improved handling of dynamic columns in the JavaScript component.
  • New: Support for Oracle Source component in SQL Server 2019.
Dynamics CRM Connection
  • Fixed: Connection exhaustion because of resource leak in the system code, causing unexplained process slowdown (Thank you, Jake).
Dynamics CRM Source
  • Fixed: Component truncated timestamp from Date-only formatted attributes.
EDI Destination
  • Fixed: Various fixes and improvements.
Google BigQuery Connection
  • Fixed: Actions that require item element failed validation.
Google Drive Connection
  • Fixed: Failed with error "Not Found" when trying to overwrite an existing file.
  • Fixed: 'Create remote directory' action in File Transfer Task will now avoid the creation of folders with same name.
GoToWebinar Connection
  • Fixed: Failed to process key fields (Thank you, Brian).
JavaScript Task
  • Fixed: Incorrect variable replacement in JSON.
  • Fixed: Disabled various destructive commands in the script editor.
  • Fixed: Improved memory consumption and management.
  • Fixed: Removed not needed exception popup dialog because the error is already reported in the log.
Jira Connection
  • Fixed: Authentication signature was invalid because of changes in the REST backend.
KRONOS Connection
  • Fixed: Failed to retrieve "Saved Reports" resource from US-hosted service (Thank you, Hardik).
Legacy Amazon S3 Connection
  • Fixed: Failed with error "The request signature we calculated does not match the signature you provided. Check your key and signing method." (Thank you, Will).
Magento Connection
  • New: Support for 'Company' resource.
Marketo Connection
  • New: Support for 'Smart Campaign' resource.
NetSuite Destination
  • Fixed: If record processing failed, the composite data became misaligned from the current main record (Thank you, Andrei).
  • Fixed: Failed with error "Object reference not set to an instance of an object" when processing 'ItemFulfillment' record (Thank you, Amol).
ODBC Destination
  • Fixed: The bulk initialization statement was needlessly retrieving rows, slowing the process (Thank you, Irawan).
OneDrive Connection
  • Fixed: Failed to process folder or file containing space in name.
PureCloud Connection
  • Fixed: Failed to retrieve data from 'Billable Usage' resource (Thank you, Anna).
  • Fixed: NULL result was incorrectly returned as integer 0 result (Thank you, Ingrid).
REST Connection
  • Fixed: Disabled the default .NET forward-slash (/) and dot (.) unescape because it breaks connectivity to resources with such characters in use.
  • Fixed: Custom -> 'Init from JSON' action didn't create a proper composite element definition.
REST Source
  • Fixed: Incorrect handling of parameters with whitespace in design.
Salesforce Source
  • Fixed: MALFORMED_QUERY error in design mode when using aggregate query with LIMIT clause.
  • Fixed: Failed with error "INVALID_TYPE: sObject type '...__r' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names." when trying to use relationship fields in SOQL statement (Thank you, Imran).
Script Component Plus
  • Fixed: Failed with error "Object reference not set to an instance of an object" when trying to open dialog in Visual Studio 2019.
SharePoint Connection
  • Fixed: Failed to delete file with ampersand (&) special symbol in the name when using File Transfer Task (Thank you, Nandu).
Xero Connection
  • Fixed: Authentication signature was invalid because of changes in the REST backend.
Zoho CRM Connection
  • Fixed: Various fixes (Thank you, Michelle).