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.
Airtable Connection
  • New: Ability to alter table or create an entire table with metadata from upstream component when running in Data Flow Task Plus.
Amazon DynamoDB Connection
  • New: Ability to alter table or create an entire table with metadata from upstream component when running in Data Flow Task Plus.
Asana Connection
  • New: Support for Task custom fields.
Avro Destination
  • New: Introduced component.
Avro Source
  • New: Introduced component.
Database Destination
  • New: Ability to alter table or create an entire table with metadata from upstream component when running in Data Flow Task Plus.
Databricks Connection
  • New: Introduced connection.
eBay Connection
  • New: Introduced connection.
Fiix CMMS Connection
  • New: Introduced connection.
Harvest Connection
  • New: Introduced connection.
HighLevel Connection
  • New: Introduced connection.
HubSpot Connection
  • New: Updated to use new v3 Marketing Email API.
Microsoft Dataverse Connection
  • New: Defined Service authentication.
  • New: Ability to alter entity or create an entire entity with metadata from upstream component when running in Data Flow Task Plus.
Microsoft Forms Connection
  • New: Introduced connection.
Microsoft Graph Connection
  • New: Ability to alter 'Site | List Item' with metadata from upstream component when running in Data Flow Task Plus.
OANDA Connection
  • New: Introduced connection.
Orah Connection
  • New: Introduced connection.
PayTrace Connection
  • New: Introduced connection.
QuickBase Connection
  • New: Ability to alter table or create an entire table with metadata from upstream component when running in Data Flow Task Plus.
REST Connection
  • New: Authentication template for OAuth 2 JWT.
REST Destination
  • New: Add support in dynamic data flows for creating a new table/entity or adding columns to a table/entity (based on upstream columns). Relevant to Airtable, Amazon DynamoDB, Microsoft Dataverse, Microsoft Graph (Sharepoint lists), QuickBase, Snowflake
REST NetSuite Connection
  • New: Support for Create/Update/Delete/Upsert actions.
  • New: Included Dataset resource.
  • New: Support for transaction records.
Salesforce Destination
  • New: Successfully processed rows are now reported in Result output. Only error rows are reported in the Error output.
Salesforce Source
  • New: A new parameter PKChunkSize to use PK Chunking bulk mode.
SAP SuccessFactors Connection
  • New: Introduced connection.
SharePoint Destination
  • New: Support for updating read-only fields.
Shopify GraphQL Connection
  • New: Introduced connection.
Snowflake Connection
  • New: Ability to alter table or create an entire table with metadata from upstream component when running in Data Flow Task Plus.
Tableau Connection
  • New: Included PAT authentication.
Veeva Vault Connection
  • New: Introduced connection.
Workday Connection
  • New: Introduced connection.
XML Source
  • New: Introduced component.