COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 2.0 library. The new version includes major improvements in usability during design time. With the addition of Database Destination (for easy Upserts and fast DB loads), COZYROC SSIS+ now offers the most powerful toolbox for developing data warehousing solutions (see also Table Difference, Lookup Plus and Sort components). The COZYROC REST framework has been further refined and you can now access, directly from Visual Studio, a rapidly growing library of pre-built templates/accelerators for consuming numerous popular third-party web APIs (currently 40+ services).

The COZYROC Team

Summary of the products available immediately for purchase:

  • SSIS+ Ultimate Subscription at $899/Year.
  • SSIS+ 2.0 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: Destination components now have the ability to preserve existing columns mapping.
  • New: Ability to access data flow component properties expression without leaving the dialog.
  • New: Vastly improved destination component columns mapping with fine-grained filtering.
  • New: Ability to select a prebuilt template as a starting point for your REST configuration efforts.
  • New: Available reusable JavaScript scripts are now easy to access directly from Visual Studio.
  • New: COZYROC components group in the SSIS Toolbox for convenience.
  • New: The library is no longer dependent on certain SSIS design-time components.
  • New: An enhanced dialog for FLEE expression definition.
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.