Saturday, September 5, 2020 - 12:00
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.
- 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 component with SQL Server.
- New: PostgreSQL support.
- New: PostgreSQL Connection Manager support.
- New: Added the Use single output option to combine insert, update, and delete records into one output.
- Introduced task with SQL Server support.
- New: PostgreSQL support.
- New: PostgreSQL Connection Manager support.
- 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: PostgreSQL Connection Manager support.
- New: Support for Microsoft.Data.SqlClient driver in SQL Server 2025.
- 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: Improved flat data processing speed.
- New: A new Compression parameter for specifying the compression algorithm.
- New: A new Level parameter for specifying the compression level.
- New: A new Encoding parameter for configuring the value sequence handling algorithm.
- New: A new OutputSplitMethod parameter for specifying whether the data is split into row groups or files.
- New: A new OutputSplitTrigger parameter for specifying what trigger to use for data splitting.
- New: A new OutputSplitArgument parameter for specifying additional information related to the split trigger mode.
- 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: Attachments will now be stored in-memory when the AttachmentVariable is of type Object.
- 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: Updated web service proxy to version 67.
- 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: Improved Create and Update performance.
- New: Support for Internal Stage API for large-scale data import.
- New: A new 'Set stream name' action to assign a name to the stream, to be used by File Transfer Task, Zip Task etc.
