COZYROC SSIS+ 1.9 now officially released

Monday, July 1, 2019 - 13:00

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

Click here to download the COZYROC SSIS+ 1.9 Suite

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.

Blackbaud Connection

New: Defined 'Financial | Fixed Asset' resource.
New: Defined 'Financial | Fixed Asset Transaction' resource.
New: Defined 'School | Meeting' resource.
New: Included definition for new /creditmemos API.
Fixed: Corrected pagination for 'Church | Action' resource.

Database Source

Fixed: Design time issue when using SELECT DISTINCT clause.
Fixed: Issue with handling nvarchar(max) columns in SQL Server.

Derived Column

New: Included encodeBase64Bytes and decodeBase64Bytes functions to work with DT_BYTES, DT_IMAGE columns.
Fixed: Many improvements and cleanup.

Excel Source

New: TrimColumnNames parameter to specify whether to remove whitespace from start/end of column names.

Jira Connection

New: Updated to use new Project read endpoint.
Fixed: Corrected default service base url.

Microsoft Graph Connection

New: Defined 'Communication | Direct Routing Call' resource.
New: Defined 'Communication | PSTN Call' resource.

Power BI connection

New: Included client_credentials authentication.

REST Connection

New: [OpenAPI Import] Support for schema types with multiple references.
New: [WSDL] integrations are now using JSON definitions everywhere.
New: [GraphQL] Improved support for mutations.
Fixed: Error when trying to use variables in GraphQL query (Thank you, Christina).
Fixed: Incomplete data transfer when streaming from one REST connection to another.
Fixed: [OData] Performance issues with large XML responses.