Released COZYROC SSIS+ 1.9 SR-1 (1.9.101.1658). The release includes the following major changes:

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.
Amazon Redshift Connection
  • New: Introduced connection.
Asana Connection
  • New: Support for Task custom fields.
Avro Destination
  • New: Introduced component.
Avro Source
  • New: Introduced component.
Azure Key Vault Connection
  • New: Introduced connection.
Brevo Connection
  • New: Introduced connection.
Data Flow Destination
  • New: Introduced ConsumersCount parameter.
  • New: Introduced InputHandling parameter.
Database Destination
  • 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.
Databricks Connection
  • New: Introduced connection.
Dynamics Business Central Connection
  • New: Defined 'Custom Endpoint' resource.
eBay Connection
  • New: Introduced connection.
Excel Destination
  • New: Support for variables for the result.
Excel Source
  • New: Support for variables as input.
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.
Jira Connection
  • New: Updated to use the new JQL endpoint to retrieve Issue.
JotForm Connection
  • New: Improved parameter entry.
JSON Logger
  • New: Introduced logger.
Message Queue Task Plus
  • New: Support for receiving a batch of messages.
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.
  • New: Included IgnoreTriggerExecution parameter to bypass plugin and flow executions.
  • New: Defined EntityMetadata and AttributeMetadata resources.
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.
  • New: Included Certificate authentication.
MongoDB Source
  • New: Support for aggregation pipelines ($project, $sort, $limit, etc.)
MQTT Connection
  • New: Introduced connection.
OANDA Connection
  • New: Introduced connection.
Orah Connection
  • New: Introduced connection.
Parallel Loop Task
  • New: Initialization speed improved 3-5x .
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.
  • New: Ability to download from File Attachment fields.
QuickBooks Online Connection
  • New: Defined endpoint to retrieve modified records for an object (CDC).
REST Connection
  • New: Authentication template for OAuth 2 JWT.
  • New: A new parameter IgnoreCertificateErrors.
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.
  • New: Support for composite data.
Salesforce Connection
  • New: Support for OAuth 2.0 code authentication.
  • New: Support for OAuth 2.0 JWT authentication.
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.
Stream Task
  • New: A new 'Set stream name' action to assign a name to the stream, to be used by File Transfer Task, Zip Task etc.
Tableau Connection
  • New: Included PAT authentication.
Veeva Vault Connection
  • New: Introduced connection.
Workday Connection
  • New: Introduced connection.
XML Source
  • New: Introduced component.