COZYROC SSIS+ 2.2 now officially released

Wednesday, February 14, 2024 - 06:55

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.
Amazon S3 Connection
  • New: Support for VPC endpoints.
BigCommerce Connection
  • New: Defined to use new Category endpoints.
Database Destination
  • FIxed: Crash in dynamic flow context, in case not all input columns are used.
Exchange Connection
  • Fixed: Failed with error "The API version 'V2' has been deprecated." on Test Connection.
File Transfer Task
  • Fixed: Failure to set remote file date/time when uploading single file (Thank you, Jeff).
Google Drive Connection
  • Fixed: File rename/move not working.
HubSpot Connection
  • New: Updated to use new v3 Owners API.
  • New: Included 'Form Submission' resource.
JavaScript Task
  • Fixed: An ocassional error "The directory is not empty" in the post-execution cleanup (Thank you, Saikit).
Pardot Connection
  • New: Included 'Visitory Activity' resource.
Parquet Destination
  • New: Automatic schema generation when attaching to upstream component.
  • New: Support for dynamic data flow.
REST Connection
  • Fixed: Error 'Field '...' has multiple schema references and can't be processed!' when using OpenAPI import (Thank you, Jack).
  • Fixed: Incomplete data transfer when streaming from one REST connection to another.
  • Fixed: RemoteFilter parameter not working when using 'Get remote files list' action in File Transfer Task.
SendGrid Connection
  • Fixed: Corrected Bounce resource metadata.
Table Difference
  • Fixed: Corrected diagnostic log to provide all columns modifications, not just the first modified column (Thank you, Colette).
Zendesk Connection
  • New: Updated 'Organization Membership' resource to use cursor pagination.
Zip Task
  • Fixed: Failed with error 'Index was outside the bounds of the array' when trying to decompress Zip package (Thank you, Anders).
  • Fixed: Compression of files greater than 8GB using the TAR format created a corrupted package (Thank you, Sri).