COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 1.8 library. In addition to the availability of many new connectors, we have invested extra effort in the overall polish of the toolkit. A new build and release process was also implemented and you will soon see improvements in both the availability and frequency of development releases and higher quality official releases. We have two announcements to make:

  • Version 1.8 will be the last version with support for SQL Server 2005 and 2008. We hope this will provide enough time to our customers to make the transition to newer and greater SQL Server versions.
  • Starting on June 1st, 2018 the cost of one SSIS+ Ultimate subscription becomes $479/year for new subscriptions. The price for existing subscribers stays the same, as long as their subscriptions are kept current.

Thank you for investing your hard-earned dollars in our products! Your investment is in safe hands and we will not disappoint you!

The COZYROC Team

Summary of the products available immediately for purchase:

  • SSIS+ Ultimate Subscription at $399.95/Year. Starting on June 1st, 2018 the price becomes $479/year.
  • SSIS+ 1.8 perpetual license at $3,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 2017.
  • New: Support for SSDT for Visual Studio 2017.
  • New: Support for Azure ADFv2 deployment.
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.
ServiceNow Connection
  • New: Support for OAuth client_credentials authentication.
Shopify Connection
  • New: Updated Fulfillment resource to use the latest endpoints.
SSH Connection
  • Fixed: Retry execution didn't handle properly disconnected sessions (Thank you, SungHwan).
Zoho Desk Connection
  • Fixed: Updating custom fields failed because of invalid expression.