Saturday, May 15, 2021 - 12:00
Released COZYROC SSIS+ 1.9 SR-2 (1.9.102.2138). The release includes the following major changes:
- 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 OutputSplitTriggerMode parameter for specifying what trigger to use for data splitting.
- New: A new OutputSplitThreshold 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: 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: Improved Create and Update performance.
- New: A new 'Set stream name' action to assign a name to the stream, to be used by File Transfer Task, Zip Task etc.
