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.

The COZYROC Team

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.
Data Flow Task Plus
  • Fixed: Unable to override input column error/truncation row disposition when using 'Derived Column' transformation (Thank you, Damian).
  • Fixed: Empty column mapping use may fail with error "Unable to cast object of type 'System.DBNull' to type 'System.String'" (Thank you, Brant).
Database Partitions Task
  • Fixed: Failed to process tables with non-clustered primary keys (Thank you, Amir).
Dynamics CRM Source
  • Fixed: Component returned date-only attributes incorrectly in UTC (Thank you, Maurizio).
  • Fixed: Component failed with error "The top attribute can't be specified with paging attribute page" when FetchXML top element was used (Thank you, Cosmin).
Excel Connection
  • Fixed: Failed to open Excel files stored in SharePoint (Thank you, Kevin).
Exchange Connection
  • Fixed: Unable to set Mailbox parameter with expression (Thank you, Carl).
  • New: Enabled support for TLS 1.1 and 1.2 protocols.
Google Drive Connection
  • Fixed: Upload action didn't update the existing file but created a new file.
Google Sheets Connection
  • Fixed: Various fixes (Thank you Karen).
HubSpot Connection
  • Fixed: Failed to read data from 'Email Campaign' resource (Thank you, Freddie).
ODBC Destination
  • New: More information reported in case of errors.
Pardot Connection
  • Fixed: Authentication token refresh may fail (Thank you, Porter).
QlikView Source
  • Fixed: Failed to process QVX_QV_DUAL fields containing numeric data (Thank you, Steven).
  • New: Performance improvement.
QuickBooks Desktop Connection
  • New: Enabled support for TLS 1.1 and 1.2 protocols.
REST Destination
  • Fix: Failed with error "Unsupported value type: System.Guid" when processing Guid input (Thank you, Kevin).
REST Source
  • Fixed: Failed with error "Unable to cast object of type 'System.Byte[]' to type 'Jurassic.Library.ObjectInstance'" when trying to read certain fields (Thank you, Gaurav).
Script Component Plus
  • Fixed: Failed to link to script when target platform version was set to SQL Server 2012 in SSDT OneDesigner.
Script Task Plus
  • Fixed: Failed to save parameters on OK (Thank you, Carl).
Send Mail Task
  • New: Vertical bar (|) is now used as attachment separator in Attachment parameter.
Shopify Connection
  • Fixed: Various fixes (Thank you Moe, Gaurav).
SSH Connection
  • Fixed: Incomplete file download when file size between 32kb and 49kb and when using SSH-2.0-FileCOPA or Syncplify server software (Thank you Kevin and Greg).
Zip Task
  • Fixed: Zip decompression failed with error "Wrong Local header signature" when processing certain large files (Thank you, Eric).
  • Fixed: Zip decompression failed with error "End of extra data" when processing certain files created with ComponentOne library (Thank you, Anders).