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.
- New: Ability to alter table or create an entire table with metadata from upstream component when running in Data Flow Task Plus.
- New: Ability to alter table or create an entire table with metadata from upstream component when running in Data Flow Task Plus.
- New: Introduced ConsumersCount parameter.
- New: Introduced InputHandling parameter.
- New: Ability to alter table or create an entire table with metadata from upstream component when running in Data Flow Task Plus.
- New: Improved bulk-load performance when using OLEDB connections. The performance is now better compared to the standard OLE DB Destination component.
- New: Improved bulk-load performance when using ODBC connections.
- New: Support for MERGE action in SQL Server database.
- New: Defined 'Custom Endpoint' resource.
- New: Defined 'Client Credentials' authentication.
- 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.
- New: Included
IgnoreTriggerExecutionparameter to bypass plugin and flow executions. - New: Defined EntityMetadata and AttributeMetadata resources.
- New: Ability to alter 'Site | List Item' with metadata from upstream component when running in Data Flow Task Plus.
- New: Included Certificate authentication.
- New: Included 'Client Credentials' authentication.
- New: Defined 'Planning People' resource.
- New: Ability to alter table or create an entire table with metadata from upstream component when running in Data Flow Task Plus.
- New: Ability to download from File Attachment fields.
- New: Defined endpoint to retrieve modified records for an object (CDC).
- New: Authentication template for OAuth 2 JWT.
- New: A new parameter IgnoreCertificateErrors.
- 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
- New: Support for Create/Update/Delete/Upsert actions.
- New: Included Dataset resource.
- New: Support for transaction records.
- New: Support for composite data.
- New: Support for OAuth 2.0 code authentication.
- New: Support for OAuth 2.0 JWT authentication.
- New: Successfully processed rows are now reported in Result output. Only error rows are reported in the Error output.
- New: Ability to alter table or create an entire table with metadata from upstream component when running in Data Flow Task Plus.
- New: A new 'Set stream name' action to assign a name to the stream, to be used by File Transfer Task, Zip Task etc.
