COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 2.2 library. The new version includes support for 37 additional applications. We have introduced a new Derived Column transformation component, a powerful replacement of the standard Derived Column transformation with support of expressions in JavaScript. The COZYROC REST framework has been further improved with support for GraphQL and OData APIs.

The COZYROC Team

Summary of the products available immediately for purchase:

  • SSIS+ Ultimate Subscription at $1199/Year.
  • SSIS+ 2.2 perpetual license at $7,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 Visual Studio 2022.
Asana Connection
  • Fixed: Various fixes and improvements (Thank you, Stewart).
Constant Contact Connection
  • Fixed: Failed with error "Invalid Pagination parameters: If 'next' is provided, no other parameters may be present." (Thank you, Dinesh).
Data Flow Task Plus
  • Fixed: Failed with error "A truncation error occurred on the specified object of the specified component." when using COZYROC Excel Source component (Thank you, Jason).
Dynamics NAV Connection
  • New: Enabled support for TLS 1.1 and 1.2 protocols.
Google Analytics Connection
  • New: Updated to use new OAuth2 2.0 authorization addresses.
Google BigQuery Connection
  • New: Updated to use new OAuth2 2.0 authorization addresses.
Google Drive Connection
  • New: Updated to use new OAuth2 2.0 authorization addresses.
Google Sheets Connection
  • New: Updated to use new OAuth2 2.0 authorization addresses.
HubSpot Connection
  • Fixed: Various fixes and enhancements.
  • Fixed: Infinite loop when trying to retrieve data from 'Contact' resource (Thank you, Geoff).
JavaScript Component
  • Fixed: Visual Studio crash after initial script selection.
KRONOS Connection
  • Fixed: Defined identifier field type was not large enough.
Mailchimp Connection
  • Fixed: Missing user-defined parameters from Create and Update actions.
  • New: Support for address merge fields (Thank you, Hardy).
PureCloud Connection
  • Fixed: Failed to retrieve all data from 'User Status Detail Query' resource (Thank you, Henrik).
  • Fixed: Included definition for missing fields in 'Conversation Detail Query' resource.
QuickBooks Destination
  • Fixed: Failed to create metadata for 'JournalEntry' object (Thank you, Chris).
REST Source
  • Fixed: Available endpoints didn't update after definition of 'Extended Metadata'.
Sage Connection
  • Fixed: Various fixes (Thank you, Adam).
Salesforce Source
  • Fixed: Id fields from related objects missing (Thank you, Ranjan).
  • Fixed: Metadata of certain related fields was not configured.
  • Fixed: Failed with error 'Unhandled type: urnRecordTypesSupported' (Thank you, Allen).
Smartsheet Connection
  • Fixed: clear parameter was not handled properly in 'Sheet Data' resource Create/Update action (Thank you, Kwame).
Sort Plus
  • Fixed: Crash with error "System.ArgumentException at System.Collections.Generic.IntrospectiveSortUtilities.ThrowOrIgnoreBadComparer..." (Thank you, John).
Twitter Connection
  • New: Included definition for tweet post (Thank you, Steve).
Zoho CRM Connection
  • Fixed: Authentication errors because of failed token refresh (Thank you, Ramu).