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.
ActiveCampaign Connection
  • New: Introduced connection.
ADP Connection
  • New: Introduced connection.
Blackbaud Connection
  • New: Introduced connection.
ClickSend Connection
  • New: Introduced connection.
Close Connection
  • New: Introduced connection.
Copper Connection
  • New: Introduced connection.
Data Flow Task Plus
  • New: Support for Azure Flexible File Source and Destination components.
  • New: Context menu item "Remove Static Columns" when right-clicking on a component.
  • New: SSDT installation is no longer required during runtime.
Database Destination
  • New: Introduced component.
EDI Source
  • New: A new optional attribute segname for segment element in configuration file. If specified, the component will provide segment name information.
Elasticsearch Connection
  • New: Introduced connection.
Excel Destination
  • New: Ability to reference sheet by index (:index) when the sheet name is unknown.
Excel Source
  • New: Ability to reference sheet by index (:index) when the sheet name is unknown.
File Transfer Task
  • New: The result returned from 'Get remote files list' action can now be iterated using the standard 'Foreach ADO Enumerator'.
FTPS Connection
  • New: Support for TLS 1.3.
Google BigQuery Connection
  • New: Support for service account authentication.
Google Drive Connection
  • New: Support for shared drives.
GoToWebinar Connection
  • New: Support for RFC 6749 compliant OAuth2 authentication.
  • New: Updated to GoToWebinar 2.0 REST API.
IMAP Connection
  • New: Support for TLS 1.3.
JSON Destination
  • New: Introduced component.
JSON Source
  • New: Introduced component.
Legacy Amazon S3 Task
  • New: The result returned from 'Get remote files list' action can now be iterated using the standard 'Foreach ADO Enumerator'.
Linkedin Connection
  • New: Introduced connection.
monday connection
  • New: Introduced connection.
NetSuite Connection
  • New: Updated web service proxy to version v2019.2.
NetSuite Source
  • New: Support for join fields in a saved search.
  • New: Improved support for custom fields in a saved search (Thank you, Mauro).
OpenAir Connection
  • New: A new parameter ServerHost to support the new OpenAir service host requirement. The old ConnectionType parameter is no longer relevant and has been removed.
Pipedrive Connection
  • New: Introduced connection.
POP3 Connection
  • New: Support for TLS 1.3.
QuickBase Connection
  • New: Introduced connection.
QuickBooks Desktop Connection
  • New: Updated QuickBooks Online web service proxy to version 43.
  • New: A new parameter 'Start on Open' in QuickBooks Desktop Edition Gateway to automatically start the gateway when the application is opened.
  • New: Support for QuickBooks Online sandbox environment.
Receive Mail Task
  • New: The result returned from 'Get mail list' action can now be iterated using the standard 'Foreach ADO Enumerator'.
REST Connection
  • Breaking Change: Resource.Field.Default attribute has been removed from the configuration schema.
  • New: Enable retrieving API tokens within a modern Chromium-based web browser component (as an alternative to the IE-based one).
  • New: OpenAPI import.
  • New: Authentication template for Google User Account.
  • New: Authentication template for Google Service Account.
  • New: Authentication template for Amazon Web Services Signature v4.
  • New: Iterator template for OData services.
Sage Business Cloud Accounting Connection
  • New: Introduced connection.
Salesforce Connection
  • New: Updated web service proxy to version 48.
SendGrid Connection
  • New: Introduced connection.
SharePoint Connection
  • New: Experimental feature to explicitly specify authentication token when using MFA-enabled service. For further information please review 'Establish connection to MFA-enabled service' Quick Start.
  • New: Support for on-premises servers that use ADFS authentication.
SharePoint Destination
  • New: An enhanced configuration dialog with improved columns mapping page.
SharePoint Source
  • New: An enhanced configuration dialog with improved output columns page.
Shopify Connection
  • New: Support for cursor-based pagination process.
SMTP Connection
  • New: Support for TLS 1.3.
SSH Connection
  • New: If key-file authentication fails, the connection will attempt password-only authentication (Thank you, Pavel).
Table Difference
  • New: A new 'Diagnostic Log' output to analyze the differences on a more granular level.
Tableau Connection
  • New: Introduced connection.
Teamwork Connection
  • New: Introduced connection.
UiPath Connection
  • New: Introduced connection.
Xero Connection
  • New: Support for OAuth2 authentication.
YouTube Connection
  • New: Introduced connection.