SSIS+ 1.9 + Library builds

Library 2.3.1.4420 Published: Thursday, June 4, 2026 - 10:11

64-bit (x64) SQL Server 2012-2025

32-bit (x86) SQL Server 2012-2025

New: [Parquet Destination] More efficient creation of flat Parquet files
Fixed: [Database Destination] COMException when executing DB2 or Informix bulk inserts in a loop. - 4703
New: [Dynamics Business Central] Removed non-essential parameters from Entity resource actions. Introduced actions 'Custom Endpoint' resource. - 4702
[Fixed]: [Base] Resolve "Alert InfoBox not scaling correctly" - 4688
New: [Database Destination] More descriptive errors when the information required to create an SQL Server temporary table cannot be retrieved. - 4694
New: [Google Drive] Move the Google Drive file or folder to the trash during Delete and Rename operations, in case the user permissions don't allow permanent deletion. - 4697
New: [XML Destination] Support XML schema creation from a component metadata schema.
Fixed: [XML Source] Support for reading simple elements and their attributes.
New: [JSON Source] Support for reading primitive arrays.
New: [JSON Source] Examine the entire JSON source string to identify columns.
Fixed: [JSON Source] Incorrect column names for object properties when the source is a string. - 4655
New: [PostgreSQL] Connection manager that supports password-based authentication, Microsoft Entra ID, Google Cloud IAM, and AWS IAM - 4596
Fixed: [Veeva Vault] Improved Veeva.setPicklistValue to process more than one picklist field. - 4692
Fixed: [Base] Prioritize case-sensitive mapping when columns differ only by casing. - 4687
Fixed: [Base] Relaxed Utils.EnumerateStreams processing to be able to process standard Stream objects. - 4689
New: [Salesforce Marketing] Added a REST Configuration - 4686
New: [Hubspot] Support for OAuth 2 authentication - 4678
New: [ZenDesk] Support for custom objects
Fixed: [ZenDesk] Pagination for some resources - 4684
Fixed: [Snowflake] Batching support for Upsert/Update/Delete
Fixed: [Snowflake] Empty row values handled correctly for all types, replaced by null/empty byte array
Fixed: [Snowflake] SHOW TABLES takes in account the context
New: [Snowflake] Introduce Custom Statement resource in REST Source and REST Destination - 4666
Fixed: [Base] Various issues with custom Editors UI in high-DPI monitors. - 4668
Fixed: [Google Analytics] Updated deprecated endpoint - 4680
Fixed: [REST Connection Manager] Crash when "fx" button for dynamic auth parameters is used with a token-based authentication - 4679
Fixed: [JSON Destination] If using decimal, currency and similar output columns, the JSON output had unexpected text like "$numberDecimal" - 4674
New: [Docusign] Introduced a Docusign REST configuration - 4184
Fixed: [Dynamics Business Central] Removed the API version from the custom url. It is not needed. - 4671
New: [Data Flow Task Plus] Workaround for a validation bug in the Flat File Source component when using a Unicode source file. When saving the Data Flow Task Plus editor, ValidateExternalMetadata is set to True on the Flat File Source component, and DelayValidation is set to True on the Data Flow Task Plus. - 4667
New: [Veeva Vault] Included Create action definition for objects. - 4670
New: [Procore] Included project endpoint in 'Direct Cost Line Item' resource. - 4669
Fixed: [Google Drive] Cannot rename a file located in a Shared Drive. - 4660
New: [MongoDB] Support for connecting to MongoDB 8.1 or later - 4662
Fixed: [Database Destination] Provide a clear error message when the component fails to connect.
Fixed: [Database Source] Provide a clear error message when the component fails to connect. - 4656
Fixed: [Data Flow Task Plus] Issue with Dynamic Aggregate when targeting SQL2025 - 4665
Fixed: [XML Source] Prevent asking twice to initialize the schema from a variable. - 4663
New: [Veeva Vault] Included filter endpoint for easier object querying. - 4659
Fixed: [Query] Exception when using Microsoft OLE DB provider for SQL Server - 4657
Fixed: [XML Source] Regression affecting metadata copying.
Fixed: [XML Source] Resolved an issue where repeated elements in the root element were not supported.
Fixed: [JSON Destination] Regression affecting inputs and columns creation from a generic schema.
New: [JSON Destination] Added support for arrays of primitive types. - 4650
Fixed: [Base] Fixes & improvements testing of connectivity of Connection Managers - 4642
New: [Procore] Included 'Client Credentials' authentication. Defined 'Planning People' resource. - 4654
New: [Mail] Add support for moving mail in Exchange and IMAP connections (used with MailTask.js) that doesn't leave a copy of the moved emails in the "Deleted" folder - 4644
New: [Sort+] Support for dynamic data flows - 4481
Fixed: [Parquet Source] Support for all timestamp and time types with appropriate scaling.
New: [Parquet Source] Support for reading byte arrays.
New: [Parquet Source] Support for reading maps and lists containing primitive types.
Fixed: [Parquet Destination] Support for reading empty lists.
New: [Parquet Destination] Support for various compression methods and compression levels.
New: [Parquet Destination] Support for specifying the use of dictionary and delta binary packed encoding.
Fixed: [Parquet Destination] All timestamp and time types are written according to the scale and type specified in the schema.
Fixed: [Parquet Destination] Supports writing empty list elements.
New: [Avro Source] Support for all timestamp and time types with appropriate scaling.
New: [Avro Source] Support for decimals with appropriate precision and scale.
Fixed: [Avro Source] Proper columns and types for union fields.
Fixed: [Avro Source] Improved serialization of Map fields to JSON.
New: [Avro Source] Support for arrays of primitive types.
New: [Avro Destination] All timestamp and time types are written according to the scale and type specified in the schema.
New: [Avro Destination] Decimal types are written according to the precision and scale specified in the schema.
New: [Avro Destination] Supports writing empty array fields.
Fixed: [Avro Destination] Supports writing empty array fields.
Fixed: [JSON Source] Incorrectly created columns for nested arrays.
Fixed: [JSON Destination] Incorrectly created columns for nested arrays. - 4349
New: [Base] Support for TLS 1.3 - 3299
New: [Avro Destination] Introduced a "Codec" property - 4629
Fixed: [Mail] Regression issue with support of non-JWT token Microsoft Authentication for IMAP and SMTP - 4646
New: [Base] Warn if a package is executed on an older SSIS+ version than it was designed on - 4634
New: [OpenPGP Task] Add a property EncryptionAlgorithm (default value Cast5) - 4627
Fixed: [Salesforce] Incorrect parameters for OAuth2 Web Server authentication
Fixed: [Salesforce] Issue with high-DPI hid the the token input fields - 4638
Fixed: [Gmail] Issue with token not refreshed when using IMAP and SMTP
Fixed: [Exchange Online] Issue with token not refreshed when using IMAP and SMTP - 4639
New: [Amazon S3] When uploading a file automatically set a proper Content-Type according to its extension.
Fixed: [Amazon S3] The Content-Type in Additional Options was ignored and application/octet-stream was always used - 4641
Fixed: [Base] Resolve "Small issue with the abortable form scaling" - 4640
New: [Base] Support for cancelling "Test Connection" operation, if it takes too long. - 4637
Fixed: [Database Source] Remove the validation error for unknown database - 4635
Fixed: [MongoDB] Could not load file or assembly 'MongoDB.Driver.Legacy' or one of its dependencies - 4633
Fixed: [File Transfer Task] Better error message when the task fails due to finding no file to send. - 4631
New: [Databricks] Client Credentials authentication
Fixed: [Databricks] Streaming support - 4508
Fixed: [IMAP] Issue with Google OAuth failing during runtime
Fixed: [SMTP] Issue with Google OAuth failing during runtime - 4628
New: [NetSuite REST] Included query endpoint.
Fixed: [NetSuite REST] Corrected single endpoint response handling. - 4630
New: [REST] Configuration that uses the Salesforce GraphQL API
Fixed: [GraphQL] Guard against race conditions
Fixed: [GraphQL] Improved handling of external Query and Mutation resources and required parameters. - 4428
New: [Shopify] Add OAuth Client Credentials authentication - 4626
Fixed: [Veeva Vault] Proper handling for multiple values in picklist field. - 4625
New: [CDC] Oracle LogMiner Source - 4603
New: [PureCloud] Defined 'Conversation Survey Response' resource. - 4623
Fixed: [NetSuite REST] Issue with OAuth authentication's code_challenge parameter - 4621
Fixed: [REST] OpenAPI importer fails silently upon attempting to display a long warning text - 4580
Fixed: [Amazon DynamoDB] Wrong contentType lead to HTTP 404 errors - 4618
Fixed: [Amazon DynamoDB] Error "Invalid URI: The hostname could not be parsed)" - 4616
New: [Ebay] Add support for digital signatures (EU/UK sellers) - 4389
Fixed: [License Manager] Issue with Turkish locale - 4614
New: [REST] Allow using customers' app in all Google services configurations - 4605
Fixed: [PureCloud] Incorrect Session authentication - 4612
New: [Parquet Source] Automatic handling of forward-only streams (load them in memory) - 4608
Fixed: [Base] Project-level connection getting improperly released after Execute Package Task completion, even with RetainSameConnection = True
Fixed: [REST] Prevent incidents of HTTP requests missing authentication-level parameters due to race conditions. - 4595
Fixed: [Pipedrive] The Team resource didn't work. Redirected to the new LegacyTeams endpoints. - 4609
Fixed: [Data Flow Task Plus] Static columns in the results output of destinations were not removed when using the "Remove static columns" command. - 4606
New: [REST Source] Don't automatically select newly added fields in RCM unless the Resource or the Endpoint is changed.
Fixed: [REST Source] Crash when copying metadata with complex fields present (newly introduced functionality in 2.3) - 4604
New: [JavaScript] Support custom title, description and documentation link in JS Task and JS Component editors. - 4599
Fixed: [JavaScript] When executing a JS script, create a temporary JS file only when debugging is enabled. - 4598
Fixed: [JavaScript] Cannot compile script when open generic method is called.
New: [JavaScript] Clr Array wrapper. - 4578
New: [Dynamics Business Central] Support for 'Client Credentials' authentication. - 4593
Fixed: [MQTT] Prevent MqttClient ObjectDisposedException during garbage collection (failed integration test) - 4590
Fixed: [Database Destination] Runtime error when using PostgreSQL connection, due to missing Npgsql.dll dependency - 4589
New: [CDC] PostgreSQL support in Change Data Capture components - 4553
Fixed: [JSON Destination] Regression issue outputting numeric values
Fixed: [JSON] Regression issue in JSON Source and JSON Destination with a missing NTEXT column with JSON child elements - 4581
Fixed: [File Transfer Task] The folders and files in the Remote File Browser were not always sorted - 4584
New: [File Transfer Task] When attempting to download Google document formats, instead of failing, automatically export them to the corresponding Microsoft Office formats - 4482
Fixed: [Base] Issue executing packages on machines where Visual Studio 2026 and SQL Server 2025 are both installed - 4575
Fixed: [REST] Issue with escaping XML characters - 4583
New: [REST] Enrich the verbose logging - 4555
New: [SugarCRM] Included required parameter to retrieve deleted records. - 4579
New: [Database Destination] Improve the speed of the inserts with ODBC drivers.
New: [Database Destination] In ODBC bulk mode support for SQL Server time, datetime2, and datetimeoffset data types.
Fixed: [Database Destination] In ODBC don't use float numbers for numeric columns. - 4475
Fixed: [KRONOS] Issue with 'Create' action in 'Time Punch' resource. - 4491
New: [REST] Apache Hadoop REST configuration (WebHDFS) - 4399
New: [GoFormz] REST Configuration - 4576
Fixed: [REST] High-DPI issue that hid the "Variables" button when configuring parameters in REST Source and REST Destination. - 4568
New: [GraphQL] Better coloring of queries & mutations - 4570
New: [Database Source] Introduce "Timeout" property with default value of 60 seconds
New: [Database Destination] Set default Timeout property value to 60 seconds - 4571
New: [Base] Support for licensing Developer Edition in SQL Server 2025 (Standard and Enterprise) - 4569
Fixed: [XML Source] Resolve issue with nested outputs with underscore in their names - 4565
Fixed: [JSON Source] Attempting to initialize schema with JSON with null values lead to an error
Fixed: [JSON Source] Issue when initializing schema with JSON that contains multiple objects of the same type - 4566
Fixed: [XML Source] When the source file name is in a variable, the file remains locked after reading it. - 4567
New: [Visual Studio] Better assist resolving SSDT/SSIS Projects incompatibility issues. - 4564
New: [Installer] Show build number or patch number (for unofficial builds) in installer's product name. - 4560
New: [REST] Better display of SSIS variables in the Source and Destination parameters
New: [Base] Better display of SSIS variables in Text Editor popup - 4559
Fixed: [Autodesk Construction Cloud] Various issues - 4558
Fixed: [File Transfer Task] Issue when download a file with colon from SFTP
Fixed: [File Transfer Task] Missing tooltip to warn about files with special characters in the FTP Browser - 4557
New: [Twilio] Support for Basic authentication (API Key and Account SID) - 4549
Fixed: [Base] Improved error messages related to DTS_E_INDUCEDTRANSFORMFAILUREONERROR errors - 4554
Fixed: [Data Flow Task Plus] In Database Destination, when creating a table, set default values for scale and precision for numeric/decimal type when they are not defined
Fixed: [Data Flow Task Plus] In Database Destination, when creating a table, datetime column is created as date column - 4551
New: [Avro Source] Support for reading data when decompressing in memory multi-archive files
New: [Parquet Source] Support for reading data when decompressing in memory multi-archive files
New: [JSON Source] Support for reading data when decompressing in memory multi-archive files
New: [XML Source] Support for reading data when decompressing in memory multi-archive files - 4518
Fixed: [Snowflake] Include in JWT authentication the same optional parameters as in OAuth2 authentication - 4546
Fixed: [REST] Issue using variables with newlines within a single parameter value in REST Source and REST Destination - 4550
New: [Base] Improved support for offline connections (better design-time errors and visual cues in some editors)
Fixed: [Database Destination] Regression issue with OLEDB validation - 4533
Fixed: [File Transfer Task] The GetListing() calls ignored the Retry settings
Fixed: [REST] Multiple Connection Managers can safely log to the same file - 4540
Fixed: [File Transfer Task] The Retry mechanism now also includes the establishing of the connection. - 4548
Fixed: [Derived Column Plus] The validation doesn't update properly after user fixes an issue with sample values.
Fixed: [Derived Column Plus] Editor scrolling issue.
Fixed: [JavaScript] The evaluation of a JS throws 'Object reference not set' in function mode.
New: [Derived Column Plus] Dynamically update evaluation result upon changing string values. - 4539
New: [Base] Smarter default mapping behavior in Destination components with composite inputs - 4543
Fixed: [MongoDB Source] Use Extended JSON for $JSON column, as the previous format (Mongo Shell syntax) didn't produce a valid JSON. - 4541
New: [Database Destination] Merge Action for SQL Server bulk mode. - 4521
Fixed: [Zip Task] Regression issue, where the task failed if the target is a folder specified in a variable - 4537

Library 2.2.102.4409 Published: Tuesday, June 2, 2026 - 18:09

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

New: [Snowflake] Make 'Database' and 'Schema' required. - 4664
Fixed: [Google Analytics] Updated deprecated endpoint - 4680
Fixed: [JSON Destination] Fix formatting of decimal values (2.2) - 4675
Fixed: [Google Drive] Cannot rename a file located in a Shared Drive. - 4661
Fixed: [Query] Exception when using Microsoft OLE DB provider for SQL Server - 4657
New: [Base] Support for TLS 1.3 - 3299
Fixed: [Mail] Regression issue with support of non-JWT token Microsoft Authentication for IMAP and SMTP - 4646
Fixed: [Database Source] Remove the validation error for unknown database - 4635
Fixed: [IMAP] Issue with Google OAuth failing during runtime
Fixed: [SMTP] Issue with Google OAuth failing during runtime - 4628
Fixed: [NetSuite] Removed code_challenge parameter base64 padding because the authentication no longer accepts it. - 4622
Fixed: [REST] OpenAPI importer fails silently upon attempting to display a long warning text - 4580
Fixed: [Amazon DynamoDB] Wrong contentType lead to HTTP 404 errors - 4619
Fixed: [Amazon DynamoDB] Error "Invalid URI: The hostname could not be parsed)" - 4616
Fixed: [License Manager] Issue with Turkish locale - 4615
Fixed: [PureCloud] Session authentication definition was incorrect. - 4613
New: [Parquet Source] Automatic handling of forward-only streams (load them in memory) - 4611
Fixed: [Pipedrive] The Team resource didn't work. Redirected to the new LegacyTeams endpoints. - 4609
Fixed: [Data Flow Task Plus] Static columns in the results output of destinations were not removed when using the "Remove static columns" command. - 4606
Fixed: [JavaScript] When executing a JS script, create a temporary JS file only when debugging is enabled. - 4601
Fixed: [REST] Issue with escaping XML characters - 4583
New: [SugarCRM] Included required parameter to retrieve deleted records. - 4579
Fixed: [Sort Plus] More robust handling of failure to delete a file from the temporary cache - 4528
Fixed: [Visual Studio] Connection Managers' Properties windows might become unusable for up to 5 minutes from loading a SSIS project (due to refresing each second). - 4478
New: [Twilio] Support for Basic authentication (API Key and Account SID) - 4549
Fixed: [Snowflake] Include in JWT authentication the same optional parameters as in OAuth2 authentication
Fixed: [Snowflake] Manual query building and handling of optional Database and Schema parameters - 4545
Fixed: [Derived Column Plus] The validation doesn't update properly after user fixes an issue with sample values.
Fixed: [Derived Column Plus] Editor scrolling issue.
Fixed: [JavaScript] The evaluation of a JS throws 'Object reference not set' in function mode.
New: [Derived Column Plus] Dynamically update evaluation result upon changing string values. - 4539
Fixed: [MongoDB Source] Use Extended JSON for $JSON column, as the previous format (Mongo Shell syntax) didn't produce a valid JSON. - 4541

Library 2.3.1.4250 Published: Monday, November 10, 2025 - 13:19

64-bit (x64) SQL Server 2012-2025

32-bit (x86) SQL Server 2012-2025

New: Support for Visual Studio 2026
New: Support for SQL Server 2025
Fixed: [EDI] Corrected the handling of escaped escape.
New: [DataFlow Destination] Support for parallel multicast reading via DataFlow Source. Added InputHandling property.
Fixed: [Sort Plus] Don't fail the component if the temporary cache can't be deleted. Instead retry and don't throw exceptions.
New: [CDC for SQL Server] Introduce CDC Task Plus and CDC Source Plus with MS SQL Server support - 4383
New: [Base] Enhanced support of stream objects to include additional information like name, hash, creation time, etc.
Fixed: [MongoDB] Issue with initializing metadata for collection with decimal128 field. Now uses DT_NUMERIC(38,18) - 4505
Fixed: [File Transfer Task] Couldn't send a file from a stream variable to another destination, due to its original file name not being stored
Fixed: [File Transfer Task] Regression when sending a byte array from a variable
New: [Stream Task] Introduced action "Set stream name" via which destination file name can be specified/amended - 4463
Fixed: [Derived Column Plus] Prevent errors related to missing error output - 4503
New: [FTPS][SSH] Updated to use the latest backend modules. - 4502
New: [Microsoft Graph] Included optional 'clear' parameter to clear sheet before sending data in 'Workbook | Sheet Data' resource. - 4500
Fixed: [Installer] A regression issue with SQL Server 2017 components not being installed. - 4497
New: [Microsoft Graph] Included handling for hyperlink fields. - 4496
Fixed: [Microsoft Graph] Unable to upload large stream from Variable.
Fixed: [Azure Files] Unable to upload large stream from Variable.
Fixed: [Box] Unable to upload large stream from Variable.
Fixed: [Box] Cannot create folder in root.
Fixed: [Databricks] Unable to upload large stream from Variable.
Fixed: [Google Cloud Storage] Unable to upload large stream from Variable.
Fixed: [Google Drive] Unable to upload large stream from Variable.
Fixed: [IBM Cloud Storage] Issues with file names with special characters (like #, %, etc.) - 4488
New: [Salesforce] Support for OAuth2 Client Credentials flow - 4492
New: [MongoDB Destination] 'KeepNulls' property to control whether to skip empty elements - 4494
New: [Install] Support for Visual Studio 2026. - 4495
Fixed: [OFTP] Race condition error "Collection was modified after the enumerator was instantiated" - 4480
New: [Base] Updated with latest modules from SSDT 17.0.1008.3 - 4493
Fixed: [REST] Resolve "External field initialization fails when the name of a field is an uppercase "Name"" - 4484
Fixed: [Data Flow Task Plus] Check for script before trying to load. - 4489
New: [REST NetSuite] Various enhancements - 4490
Fixed: [OpenPGP Task] Partial upload of decrypted to Variable file. - 4487
Fixed: [Microsoft Graph] Issues with file and folder names with special characters (like #, %, etc.) - 4485
New: [Parallel Loop Task] Decrease the initialization time of the parallel packages executors - 4461
New: [File Transfer Task] Add extra validation to not allow deferred streaming to a variable using connections that close immediately after using them - 4476
Fixed: [Visual Studio] Connection Managers' Properties windows might become unusable for up to 5 minutes from loading a SSIS project (due to refresing each second). - 4478
Fixed: [Snowflake] Various fixes - 4427
New: [PowerShell Task] Support for Information Stream and Write-Host (requires PowerShell 5.0 or later) - 4468
New: [REST] Configuration for Culture Amp and Freshdesk services. - 4473
New: [Database Destination] Improve the speed of the operation with OLEDB databases - 4348
New: [Azure Blob Storage] Added support for Container and Blob endpoints. - 4446
New: [MongoDB Source] Support for aggregation pipelines, as a more flexible mechanism than only filtering a collection. The Filter property is made obsolete by the new PipelineJSON property.
Fixed: [MongoDB] Minor fixes in MongoDB Source and MongoDB Destination - 4454
New: [Installer] Add CZSSISPlus_Restore.bat file for quick recovery from "Failed to retrieve active package." errors after SQL Server updates. - 4457
New: [XML Destination] Support for exporting to file when using a string variable destination
New: [JSON Destination] Support for exporting to file when using a string variable destination - 4460
Fixed: [Microsoft Dataverse] Modified not to suppress duplicate detection rules in Upsert when DuplicateDetectionRules parameter is set. - 4462
New: [REST] Configuration for "IBM Cloud Object Storage" service - 4323
New: [Microsoft Graph] Various enhancements and improvements. - 4458
New: [Microsoft Dataverse] Included EntityMetadata and AttributeMetadata resources. - 4456
New: [YouTube] Included APIKEY authentication. - 4455
Fixed: [Microsoft Dataverse] Update and Upsert actions didn't work properly when AlternateKey option was used - 4450
Fixed: [Parallel Loop Task] Expressions configured on 'For Each Loop' enumerator didn't work. - 4434
Fixed: [Excel Source] Issues when using a variable for the source file path. - 4449
Fixed: [Azure Services] In "Shared Key" authentication, make "Storage Account" property optional, as normally it is a part of the Server property.
New: [Azure Table Storage] Support for "Shared Key" authentication
Fixed: [Azure Table Storage] Issue when creating a table - 4440
Fixed [Excel Destination] A crash when switching from Variable to File mode - 4447
Fixed: [Azure Files] Issues with file names with special characters (like #, %, etc.)
Fixed: [Amazon S3] Issues with file names with special characters (like #, %, etc.) - 4445
New: [Excel Destination] Support for specifying the destination Excel file path as a string variable. - 4444
New: [BigCommerce] Improved actions usability by replacing usage of parameters with the use of the input data. - 4442
Fixed: [Azure Blob Storage] Issues with file names with special characters (like #, %, etc.) - 4439
New: [REST Connection Manager] Add a dialog that allows quickly making the authentication parameters dynamic. - 4438
New: [Blackbaud] New parameters for configuring own authentication application - 4436
Fixed: [Database Destination] Use LocaleID for parsing string values in numeric columns, instead of relying on the server's regional settings. - 4423
Fixed: [REST] Data conversions issues when REST Source/Destination locale is different from the system's regional settings. - 4430
New: [Salesforce] Implement OAuth2 support for Salesforce Connection Manager (JWT Bearer Flow and Web Flow) - 4382
Fixed: [General] When updating components metadata, in case the scale was different, the UI was mistakingly showing new scale as old and new as old. Fixed it. - 4431
New: [QuickBase] Included support for File fields. - 4429
Fixed: [Veeva Vault] Various fixes. - 4347
New: [Asana] Support for Project custom fields. - 4426
New: [JotForm] Improved parameter entry. - 4425
Fixed: [Database Destination] Only disallow bulk updates/upserts/delets for unknown databases (previously all operations were disallowed). - 4406
Fixed: [BigCommerce] Corrected type for video_id field. - 4421
New: [Microsoft Graph] Included definition to retrieve children of mail folder. - 4420
Fixed: [Data Flow Task Plus] Table Difference failed to process because 'Diagnostic Log' doesn't contain THUNK_COLUMN. - 4417
New: [Jira] Updated to use the new JQL endpoint to retrieve Issue. - 4416
New: [REST] New configuration for Autodesk Construction Cloud service. - 4415
New: [QuickBooks Online] Implemented endpoint to retrieve an object modified records (CDC). - 4413
Fixed: [Dynamics Business Central] Corrected Single endpoints definition to exclude pagination. - 4409
New: [Salesforce] Support for AWS VPC URLs - 4397
New: [BigCommerce] Defined 'Product | Channel' resource. - 4405
New: [MicroSoft Graph] Add test endpoint for the new Certificate authentication. Requires (Organization.Read.All or Directory.Read.All ) - 4404
Fixed: [XML Source] An error with processing XSD where xsd:extension does not define any child elements.
Fixed: [XML Source] When initializing from XSD got duplicate columns.
Fixed: [XML Source] Add more context when asking about self-referential types handling. - 4396
Fixed: [Zip Task] Remove unnecessary verification, leading to "Extra data extended Zip64 information length is invalid" error in some ZIP files. - 4400
New: [Azure Blob Storage] Included Service authentication. - 4401
New: [Microsoft Graph] Support for Certificate-based Authentication - 4385

Library 2.3.1.4114 Published: Friday, August 8, 2025 - 11:00

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

Fixed: [RabbitMQ] Failure connecting to services using TLS 1.2
Fixed: [RabbitMQ] The "EnableSSL" option was not persisted in the ConnectionString - 4392
Fixed: [Installer] Regression issue with skipping essential registry keys, affecting REST connection manager - 4391
Fixed: [Microsoft Graph] Modified to use vertical (|) bar for multi-choice selection. - 4386
Fixed: [Installer] Eliminate unnecessary deployment of multiple DLL files (some had redundant duplicates, others ended up incorrectly directly under the root C:\ folder ) - 4373
Fixed: [Amazon S3] Support for special regions like amazonaws.com.cn - 4312
New: [REST] Modify default length of ShortText to be 250 characters (consistent with other SSIS+ components). - 4376
New: [General] Support for universal JSON-based component metadata representation format, supporting composite records. Each source component allows copying the schema, while JSON, Parquet and Avro components also support initializing their metadata from such a schema. - 4308
Fixed: [Data Flow Task Plus] regression issue with missing mapping attributes in REST Destination - 4358
Fixed: [Box] Failed to retrieve list of items below the root level. - 4374
Fixed: [General] Included some missing settings in SSIS configuration XML files, related to properties editing and package upgrade - 4359
Fixed: [BigCommerce] Errors when include parameter was empty. - 4368
New: [Microsoft Graph] Included support for multi-choice SharePoint list columns. - 4367
New: [General] Update log4net.dll to a newer version with no known vulnerabilities - 4357
Fixed: [JSON Source] Memory usage optimization - 4360
New: [NetSuite] Included retrieval for InventoryNumber custom fields. - 4355
Fixed: [Query] Incorrect handling of ORDER BY in multiline queries - 4352
New: [REST] Support for custom formatted value for Date header - 4354
Fixed: [Data Flow Task Plus] NullReferenceException when Union All is without an attached output - 4340
Fixed: [VS2022] "Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version=17.0.0.0" error message. - 4356
New: [General] Unique build numbers for patches, based on build pipeline ID. Displayed in SSIS editors headings. - 4353
Fixed: [Data Flow Task Plus] NullReferenceException in REST Destination when ConfigurationVariable is not specified. NOTE: The variable is now called CreateConfigurationVariable - 4343
Fixed: [Mail] Update Microsoft Authentication for IMAP and SMTP - 4053
New: [Amazon Redshift] Introduced a new REST configuration - 4278
New: [Message Queue Task] Support for reading multiple messages in a batch. They can be processed later in Avro Source, JSON Source, XML Source and Parquet Source - 4320
New: [Microsoft Graph] Included ability to process additional parameters for Read action in Search resource. - 4345
New: "REST Configuration for Azure Key Vault" - 4309
Fixed: [XML Source] Issue with duplicate column names (now the columns in composite outputs are prefixed with the output name).
New: [XML Source] Support for mixed-content complex elements.
New: [XML Destination] Support for mixed-content complex elements. - 4330
Fixed: [REST] A regression issue "Maximum number of named properties reached" when sending a request which body contains a JSON array with thousands of elements. - 4336
Fixed: [MongoDB] Exception when using MongoDB connection, related to MongoDB.Driver.Legacy.dll - 4337
New: [REST] Configuration for Brevo service. - 4339
Fixed: [Table Difference] Improved warning messages for ignored columns. - 4338
New: [Zendesk] Defined access token refresh. - 4335
New: [General] Support for SQL Server 2025 - 4334
New: [REST] Support for Digest Authentication by introducing a way to not trigger exception when receiving a particular non-success HTTP status code - 4324
New: [Microsoft Dataverse] Included IgnoreTriggerExecution parameter to bypass plugin and flow executions. - 4332
New: [DataFlow Destination] Support for parallel reading via DataFlow Source. Added ConsumerCount property. Removed SignalEnd property. - 4317
New: [REST] Add IgnoreCertificateErrors property in REST Connection Manager - 4331
Fixed: [File Transfer Task] In REST-based connections, instead of completely ignoring remote files that have characters not allowed on Windows, display those and automatically replace the problematic characters with a dash. - 4329
Fixed: [File Transfer Task] Improve error message when no files match a filter. - 4328
New: [Jira] Included definitions in User resource. - 4326
Fixed: [Procore] Various corrections. - 4327
New: [Blackbaud] Included definitions for retrieval of custom fields data in 'Church | Constituent' and 'Church | Education' resources. - 4325
Fixed: [File Transfer Task] Uploading a file to Salesforce failed in streaming mode. - 4316
Fixed: [Parquet Destination] Corrected handling of file path variables for result.
Fixed: [Avro Destination] Corrected handling of file path variables for result. - 4321
New: [Zip Task] Add streaming support for multifile archives as Enumerable. A new property LegacyObjectResult allows for preserving backwards compatibility with streaming. The IFileInfo has a Hash property that is either CRC, when available in the archive, or SHA-1 if computed
New: [File Transfert Task] Add support for uploading files from variables containing IFileInfo and Enumerable. - 4279
Fixed: [Asana] missing reference to oauth2.js - 4315
New: [XML Destination] Support for XSD schemas with multiple possible roots
New: [XML Source] Support for XSD schemas with multiple possible roots - 4314
Fixed: [Azure Queue Storage] Issue when using shared-key authentication in create and update requests - 4311
New: [File Transfer Task] More logging messages for file download - 4310
Fixed: [REST] Better default handling of selected/ignored content types in OpenAPI import - 4303
New: [Zip Task] Faster calculation of CRC for files - 4304
Fixed: [Salesforce Source] Handling of subqueries with tablenames that end with Y (ActivityHistory -> ActivityHistories) - 4300
New: [Dynamics Business Central] Defined 'Custom Endpoint' resource. - 4298
Fixed: [Shopify] Small fixes. - 4297
Fixed: [Canvas LMS] Various fixes. - 4296
Fixed: [Procore] Various fixes and enhancements. - 4295
Fixed: [REST] Issue with OAuth 1.0 authentication - 4274
Fixed: [Tableau] Documentation issue in the readme.txt file - 4288
Fixed: [Data Flow Task Plus] With source components with multiple outputs, use dynamic metadata with the first attached output, which is not necessarly the root output.
Fixed: [Xml Source] More robust handling of elements in the XML document that are not part of the XSD schema. - 4281
Fixed: [Qualtrics] Corrected pagination. - 4282
New: [Dropbox] Defined additional file properties. - 4276
Fixed: [Parquet Destination] Issue with decimals with equal scale and precision - 4269
Fixed: [XML Source] Missing optional elements in the source XML file can lead to NullReferenceException when loading data. - 4267
New: [JSON Log Provider] Introduce support for logging to JSON format - 4264
New: [AMQP 1.0] Support for receiving/sending properties, headers, and other message context in Message Queue Task Plus - 4263
Fixed: [REST Source] In Preview don't show the "More..." button when there is an error and thus no items to display - 4270
Fixed: [REST] When importing an OpenAPI if a missing schema and type show a proper error or warning message, instead of crashing with NullReferenceException - 4261
New: [Google BigQuery] Support for creating new tables or modifying their rows in Dynamic Data Flows
New: [Google BigQuery] Support for using tables as (dynamic) resources - 4245
Fixed: [File Transfer Task] When working with REST-based connections with flat namespaces (Amazon S3, Azure Blob Storage, Google Cloud Storage), some operation like retrieving a file were slow due unnecessary listing all items in the bucket/root directory - 4250
Fixed: [REST] Remove components duplications when importing an OpenAPI configuration, resulting in more compact RCM - 4248
Fixed: [Database Source] Handle date SQL Server data type as DT_DBDATE, instead of DT_DBTIMESTAMP
Fixed: [Database Destination] Handle date SQL Server data type as DT_DBDATE, instead of DT_DBTIMESTAMP
New: [Parquet Destination] Support for Precision and Scale for schema elements (for more efficient storage)
Fixed: [Parquet Destination] Handle date fields with DT_DBDATE SSIS data type instead ofDT_DATE
Fixed: [Parquet Destination] Prevent ObjectDisposedException error in dynamic data flow context - 4247
New: [Hubspot] Updated 'Marketing Email' resource to use v3 API. - 4262
New: [REST Destination] Included ActionResult column - 4257
Fixed: [Canvas LMS] Modified to configure all identifier columns from Id template. - 4258
New: [Hubspot] Included definition for search endpoint in 'CRM Object' resource. - 4259
Fixed: [Query] Support for ORDER BY clause in T-SQL Queries - 4255
Fixed: [REST] Embedded configurations are now stored in compressed form in REST Connection Manager. Besides the smaller size, this prevents an issue with big configurations with many XML elements being lost upon saving. - 4246
Fixed: [ASN Source] Issue with the Editor not allowing to specify the FILE connection - 4249
Fixed: [REST] Prevent VS crashing when a REST configuration has mutually-referencing template fields - 4237
Fixed: [SSH Connection Manager] Don't require user password if user key file is specified. - 4244
Fixed: [File Transfer Task] The specified local target folder for downloading remote was ignored if the remote folder didn't have a trailing slash - 4243
New: [REST] Add OAuth 2.0 JWT authentication template to the RCM builder - 4240
New: [Kafka] Upgrade cilent to use librdkafka.redist 2.6.1 (OpenSSL 3.3.2, CURL 8.10.1) - 4235
New: [REST] Add support in dynamic data flows for creating a new table/entity or adding columns to a table/entity (based on upstream columns). Support for Airtable, Amazon DynamoDB, Microsoft Dataverse, Microsoft Graph (Sharepoint Lists), Snowflake, QuickBase - 4106
Fixed: [Salesforce Destination] A regression issue when no Results Output is attached - 4233
Fixed: [Data Flow Task Plus] Error when generating Parquet, Avro or JSON files in a loop. - 4226
New: [Tableau] Included PAT authentication. - 4229
Fixed: [XML Destination] Output to UTF-8 is now without BOM (a more standard behavior). - 4225
Fixed: [XML Destination] Output to UTF-8 is now without BOM (a more standard behavior). - 4222
Fixed: [Base] Eliminated as many of the compilation warnings as possible. - 4221
New: [MQTT Connection] to be used with Message Queue Task Plus - 4148
Fixed: [SAS] Updated to use crypto module used in Core module. - 4216
Fixed: [Query] Skip unnecessary loading of tables when working with SQL Clause in the Editor - 4219
Fixed: [General] Some high-DPI issues with several Connection Managers Editors - 4215
New: [Procore] Included latest definitions. - 4214
New: [SAP SuccessFactors] Included more authentications. - 4213
Fixed: [JavaScript Component] Improve performance by skipping an unnecesary second validation before the start of the execution.
Fixed: [JavaScript Component] Sometimes the validation errors where not immediately dispalyed (e.g. on input/output connect/disconnect). - 4211
New: [Database Destination] Options to automatically create (CreateTableIfMissing) and update (AddMissingColumns) a table in dynamic data flows (supported only for SQL Server) - 4134
Fixed: [Dynamic Derived Column] Removed legacy column reference regex code causing issues. - 4180
Fixed: [Data Flow Task Plus] Issue with dynamic data flow behavior of Parquet Destination, Rest Destination, Json Destination and MongoDbDestination. - 4206
Fixed: [Capsule CRM] Corrected resources where pagination is not supported. - 4203
New: [REST] Automatically bring the focus back to Visual Studio when the token retrieval completes in the external browser - 4190
Fixed: [EDI Connection] Newly introduced validation of xmltag elements in the mapping file was creating issues - 4198
New: [Power BI] Included definition to update Report datasources. - 4195
Fixed: [Amazon S3] Moving folder contents with "Rename files" action didn't work properly - 4185
Fixed: [OpenAir] APIKey is now a sensitive property of the Connection Manager - 4193
Fixed: [Kafka] Messages might not be successfully delivered if the packages completed early. - 4189
Fixed: [REST] Retrieving an access token via an external browser didn't properly report success in the browser in recent Chrome versions. - 4172
Fixed: [Data Flow Task Plus] Issue with THUNK_COLUMN being left in the output of a dynamic source component, in case there was no THUNK_COLUMN in the Error Output - 4181
Fixed: [Azure Blob Storage] Regression issue with authorization - 4179
New: [Procore] Updated with latest API modifications. - 4174
Fixed: [REST] Several configurations required an extra step when retreiving a token from an external browser - 4168
New: [NetSuite] Support for Create/Update/Delete/Upsert actions. - 4171

Library 2.2.101.4029 Published: Thursday, May 1, 2025 - 05:20

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

Fixed: [REST] Issue with OAuth 1.0 authentication - 4274
Fixed: [Tableau] Documentation issue in the readme.txt file - 4288
New: [Kafka] Upgrade cilent to use librdkafka.redist 2.6.1 (OpenSSL 3.3.2, CURL 8.10.1) - 4235
Fixed: [Qualtrics] Corrected pagination. - 4282
New: [Dropbox] Defined additional file properties. - 4276
Fixed: [Parquet Destination] Issue with decimals with equal scale and precision - 4269
Fixed: [REST Source] In Preview don't show the "More..." button when there is an error and thus no items to display - 4270
Fixed: [REST] When importing an OpenAPI if a missing schema and type show a proper error or warning message, instead of crashing with NullReferenceException - 4261
Fixed: [Database Source] Handle date SQL Server data type as DT_DBDATE, instead of DT_DBTIMESTAMP
Fixed: [Database Destination] Handle date SQL Server data type as DT_DBDATE, instead of DT_DBTIMESTAMP
New: [Parquet Destination] Support for Precision and Scale for schema elements (for more efficient storage)
Fixed: [Parquet Destination] Handle date fields with DT_DBDATE SSIS data type instead ofDT_DATE
Fixed: [Parquet Destination] Prevent ObjectDisposedException error in dynamic data flow context - 4266
Fixed: [Canvas LMS] Modified to configure all identifier columns from Id template. - 4258
Fixed: [Data Flow Task Plus] Error when generating Parquet or JSON files in a loop. - 4231
Fixed: [XML Destination] Output to UTF-8 is now without BOM (a more standard behavior). - 4225
Fixed: [SAS] Regression issue with licensing. - 4220
Fixed: [General] Some high-DPI issues with several Connection Managers Editors - 4215
Fixed: [Data Flow Task Plus] Issue with dynamic data flow behavior of Parquet Destination, Rest Destination, Json Destination and MongoDB Destination. - 4207
Fixed: [Capsule CRM] Corrected resources where pagination is not supported. - 4203
Fixed: [EDI Connection] Newly introduced validation of xmltag elements in the mapping file was creating issues - 4198
New: [Power BI] Included definition to update Report datasources. - 4195
Fixed: [OpenAir] APIKey is now a sensitive property of the Connection Manager - 4193
Fixed: [Kafka] Messages might not be successfully delivered if the packages completed early. - 4189
Fixed: [Data Flow Task Plus] Issue with THUNK_COLUMN being left in the output of a dynamic source component, in case there was no THUNK_COLUMN in the Error Output - 4181
Fixed: [Azure Blob Storage] Regression issue with authorization - 4179
Fixed: [Smartsheet] Unable to update columns of type Bit. - 4164
Fixed: [Amazon S3] Improved error reporting when returned list is empty. - 4162
Fixed: [REST] Incorrect error message "Invalid token file", when the token is specified to use DB storage - 4159

Library 2.3.1.3914 Published: Monday, December 23, 2024 - 15:28

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

Library 2.2.101.3902 Published: Thursday, December 12, 2024 - 16:46

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

New [Power BI] Improved query parameter handling in 'Dataset | Query' resource - 4157
New: [Dynamics Business Central] For entities with multiple keys, return comma-separated list of IDs in the Result output - 4139
New: [OData] Add support for returning comma separated values in ID result field for OData batch create/update/delete operations. - 4150
Fixed: [Database Destination] Memory leaky with DT_IMAGE data with Microsoft OLEDB Provider for SQL Server - 4068
Fixed: [Google BigQuery] Corrected to upload chunks that are the multiple of 256KiB in size. - 4131
New: [Derived Column Plus] function newGUID - 4140
Fixed: [REST] Implemented to set invalid date input as undefined. - 4136
New: [Derived Column Plus] utility function stringToGUID - 4132
Fixed: [REST] Issue when failing to obtain a non-persistent access token - 4127
Fixed: [JavaScript Component] Smarter searching for columns with a [column] template and better error message when a referenced column is missing. - 4122
Fixed: [REST Source] A regression issue with displaying the final row that allows loading more pages of results - 4118
Fixed: [Mapping] A column mapping-related issue affecting source components that don't have an error output - 4115
Fixed: [Asana] Issue with retrieving of task's tags - 4107
New: [NetSuite Destination] Specify a predefined deletion reason "other" to prevent errors with missing reason. - 4102
Fixed: [Azure Blob] Some issues when listing files via File Transfer Task - 4096
Fixed: [BigCommerce] Included explicit definition not to include fields for single Read. - 4092
Fixed: [REST] Long resource names were not fully visible in REST Source and REST Destination - 4081
Fixed: [GraphQL] Mutations of some GraphQL APIs like Shopify were not properly classified as create/update/delete/upsert action - 4083
Fixed: [GraphQL] Using mutations with no top-level scalar fields failed with "Field must have selections". Now, there's a an option to select the field with the record ID, returned in the response. - 4074
New: [REST] Add extra logging for troubleshooting issues with token refreshes - 4080
Fixed: [Parquet] Show an error message when schema is in incorrect JSON format - 4073
New: [Microsoft Graph] Defined 'Communication | Call' resource. - 4076
Fixed: [Database Destination] In SQL Server default column values were not taken in account in UPDATE and UPSERT actions. New property KeepNulls allows modifying the behavior. - 4067
Fixed: [Base] Implemented to report error when properties retrieve crashes. - 4069
Fixed: [SMTP] Button "New" not visible when creating a token - 4059
Fixed: [IMAP] Button "New" not visible when creating a token - 4056
New: [Parquet Source] Support for using a stream variable as a source - 3988
Fixed: [Installation] Windows 365 Cloud PC loses remote connectivity after installing SSIS+ 2.2 - 4042
Fixed: [QuickBase] sortBy parameter was not properly processed. - 4039
Fixed: [Database Source] Variable values incorrectly inlined in the SQL statement upon saving changes in the component editor
Fixed: [Database Source] Editor not properly resizing - 4030
Fixed: [QuickBase] QuickBase.getData function didn't prepare proper result for field names with invalid characters. - 4034
Fixed: [MongoDB Destination] Don't require "_id" fields to be 24 digit hex string in "Replace", "Update", "Delete" actions
Fixed: [MongoDB Destination] Restored the upsert logic when using "Replace" action - 4026
Fixed: [REST] Modified to avoid setting the action definition endpoint when configuring with the defined service endpoint. - 4027
Fixed: [PowerShell] Error "The member 'FileList' in the module manifest is not valid: Value cannot be null." when trying to use some modules - 4014
Fixed: [Dynamics Business Central] Handle updates with multi-key entities.
Fixed: [Dynamics Business Central] Replace NULL input data for string fields with empty string.
New: [Dynamics Business Central] Faster processing of big XML responses. - 4020
Fixed: [Microsoft Graph] Corrected metadata for 'Assigned Products' field. - 4021
Fixed: [Zoho CRM 2] Few small fixes. - 4018
New: [OData] Add support for Composite keys in OData Update/Upsert/Delete requests.
Fixed: [OData] Display non-cryptic errors in case OData request returns an error response. - 4017
Fixed: [XML Destination] Composite records were ignored in case their parent element was defined (or inferred) as optional - 4015
Fixed: [Snowflake] Improve parameter names of the Key-Pair authentication and remove test default values - 4013

Library 2.2.101.3755 Published: Friday, September 6, 2024 - 14:00

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

New: [SSH] Support for ecdsa-sha2-nistp384 and ecdsa-sha2-nistp521 host key algorithms - 4010
Fixed: [Google Drive] Issue when moving multiple files with the same path. - 4009
New: [File Transfer Task] Add a Refresh button to the File browser dialog - 4008
Fixed: [OData] An issue with parameters referencing non-existent UI editor - 4006
Fixed: [GraphQL] Regression issue in GraphQL support for Monday.com and KnowBe4 services - 4005
New: [REST] Warn that manually changing the token expiration time might comporomise the token refresh process - 4004
Fixed: [JavaScript] Crash when multiple JS Editor windows are simultaneously opened in the corresponding Visual Studio instances - 3995
Fixed: [Shopify] Improve clarity that only "Token" authentication is supported - 4002
Fixed: [REST] Issue with duplicate authorization header, when retrying a failed request - 3996
Fixed: [REST] CloneObject used for External resource configuration didn't set... - 3999
Fixed: [Zoho CRM 2] NULL date/time fields were incorrectly set to current date/time during update. - 3998
Fixed: [Zoho Desk] Custom field set expression was invalid. - 3997
New: [Power BI] Defined client_credentials authentication. - 3987
New: [Parquet Destination] Automatically generate schema from upstream component columns
Fixed: [Parquet Destination] Default input name is corrected to be "Parquet Destination Input" - 3972
New: [JSON Destination] Automatically initialize metadata upon attaching an upstream component - 3986
Fixed: [GraphQL] Mutations were not showing in the list of resources in REST Destination, if a resource with the same name exists in REST Source
New: [GraphQL] Support for subqueries - 3973
New: [Shopify] Update Fulfillment resource to use latest endpoints. - 3989
New: [Pardot] Included 'Visitor Activity' resource. - 3978
New: [Hubspot] Included 'Form Submission' resource. - 3980
New: [BigCommerce] Implemented to use new Category endpoints. - 3977
New: [Blackbaud] Small enhancements. - 3979
Fixed: [Zip Task] Issue with TAR compression of files, with sizes bigger than 8GB - 3969
Fixed: [JavaScript Task] An ocassional error "The directory is not empty" in the post-execution cleanup. - 3960
Fixed: [Zip Task] A regression issue with Zip AES decompressing. - 3962
Fixed: Transferring a file from one REST-based File Manager to another via In-memory stream variables trims data - 3963
Fixed: [Base] The escaping of . in names of composite outputs/inputs of components is now _ (for consistency). - 3964
New: [File Transfer Task] Extended support for renaming/moving files and folders in the context of REST connections - 3957
Fixed: [Google Drive] Workaround for rename/move not working (v3 API documentation might be incorrect?) - 3956
Fixed: [File Transfer Task] For "Get remote file list" with REST connections, folders couldn't be excluded by "RemoteFilter" expression - 3954
Fixed: [File Transfer Task] Sometimes the selection in the File Browser didn't activate properly the OK button in the dialog. - 3952
New: [GraphQL] Support for custom mutations. - 3930
Fixed: [REST Source] Configured truncation/error settings for a column were not take in account. - 3942
Fixed: [Base] Modified to permit illegal characters in serialize/deserialize. Otherwise, the cloning of EDI configuration fails. - 3950
Fixed: [File Transfer Task] Path was not always configured with the correct separator. - 3948
New: [WSDL] Support JSON-based definition of the authentication and its embedding in the SOAP envelope - 3891
Fixed: [Blackbaud] Corrected Read.Result definition for 'NXT | Constituent' resource. - 3945
New: [REST] Enable overriding User-Agent via an HttpCookie parameter - 3939
Fixed: [Snowflake] Allow retrieving a token in COZYROC Cloud. - 3937
New: [Jira] Updated to use new Project read endpoint. - 3943
New: [Excel Source] Property TrimColumnNames to specify whether to remove whitespace from start/end of column names - 3931
Fixed: [ArcGIS] Regression issue with token refresh - 3940
New: [OpenAPI Import] Support for schema types with multiple references - 3935
New: [Shopify] Replaced value_type with type in metafield. - 3932
Fixed: [Parquet] Issues with composite records supports
Fixed: [Parquet] Change the default column length for string columns to 250 - 3928
New: [EDI Source] Reading from a stream waits until the stream is available for reading. - 3898
Fixed: [Table Difference] Have a row for each difference among comparable rows, not just the first difference - 3923
Fixed: [Base] Use Secure cookies to prevent vulnerabilities when using HTTP - 3925
Fixed: [Derived Column Plus] Various functional, stability and performance issues - 3866
Fixed: Regression when File Transfer Task with SSH connection is used within a loop - 3921
Fixed: [GraphQL] Issue with "variables" parameter in REST Source - 3919
New: [REST] Support for DT_STR and DT_TEXT fields. - 3913
New: [Procore] Updated to include latest API enhancements. - 3912
Fixed: [SSH] When retrying executions after a failure, make sure that a disconnected sessions gets reconnected - 3893
New: [Blackbaud] Included new resources 'Financial | Fixed Asset' and 'Financial | Fixed Asset Transaction'. Corrected pagination for 'Church | Action' resource. - 3906
Fixed: [Google Cloud Storage] Corrected OAuth authentication definition. - 3905
New: [Zendesk] Updated 'Organization Membership' resource to use cursor pagination. - 3904
Fixed: [REST] Increased result Id column length. - 3902
Fixed: [Google BigQuery] Corrected expression for Job.Create action. - 3899
Fixed: [Jira] Corrected TransitionT update. - 3901
New: [ServiceNow] Included support for OAuth client_credentials authentication. - 3900
Fixed: [Exchange] Removed Test definition because it is not needed. - 3896
New: [Base] Address XML External Entity potential vulnerabilities - 3895
Fixed: [Database Destination] Crash in dynamic flow context, in case not all input columns are used - 3892
Fixed: [JavaScript] Editor might crash in JavaScript Component and [Derived Column Plus] after the first pressing of OK button - 3884
Fixed: [REST] Better handling of NULL/nil values from XML responses - 3883
Fixed: [QuickBase] Configure field names to exclude special dot (.) character. - 3880
New: [JavaScript] Function to return input column names - 3877
Fixed: [OData] performance issues with large XML responses - 3850
Fixed: [JavaScript] issues with Task and Component parameters copy&pasting - 3873
New: [Microsoft Graph] Included two new resource definitions: 'Communication |... - 3874
Fixed: [FLEE] Expression editor was not highlightning properly some keywords and SSIS variables
New: [Editor] Have a distinctive highlight of SSIS variables in various places where SQL-like expressions are used - 3869
Fixed: [SendGrid] Corrected Bounce resource metadata. - 3867
New: [JavaScript] Include detailed stack trace information in dot template expressions evaluation (REST configuration) and in other contexts, as well. - 3851
Fixed: [Hubspot] Corrected metadata for Owner resource. - 3864
New: [Base] When previewing data in Database Source, REST Source and Salesfore Source differentiate b/n NULL and empty strings - 3853
New: [Blackbaud] Defined 'School | Meeting' resource. - 3862
Fixed: [FLEE Expressions] Simplified usage of string and date variables - 3849
Fixed: [Jira] Corrected default service base url. - 3860
Fixed: [Derived Column Plus] Getting error "The method call is ambiguous" - 3856
New: [Derived Column Plus] Include encodeBase64Bytes and decodeBase64Bytes functions to work with DT_BYTES, DT_IMAGE columns - 3858
Fixed: [WSDL] Error in addSecurityBody when using custom authentication
Fixed: [WSDL] When analyzing the types in the response, by default prefer direct child types instead of inherited types - 3857
Fixed: [Base] Error "Block length does not match with its complement." - 3843
Fixed: [REST] There are situations where the read endpoint might be undefined,... - 3852
Fixed: [OData] Issue with Edm.DateTimeOffset support. Now using DT_DBTIMESTAMP data type. - 3848
Fixed: [Amazon S3] Support for VPC endpoints - 3840
Fixed: [Microsoft Graph] Implemented to remove symbols from list column names... - 3845
Fixed: [Hubspot] Updated to use DT_UI8 type for id fields. - 3844
New: [Base] Preserve selected output columns when refreshing source components' metadata - 3822
New: [Blackbaud] Included definition for new /creditmemos API. - 3841
Fixed: [REST] Modified to ignore undefined values when handling structured fields. - 3836
New: [Blackbaud] Included additional metadata in 'Church | Gift' resource. - 3835
Fixed: [Kafka Connection] Missing icon
Fixed: [AMQP Connection] Missing icon
Fixed: [RabbitMQ Connection] Missing icon
Fixed: [All Connections] Missing icon when project is loaded directly in VS 2019 and 2022 - 3829
Fixed: [Zoho] Included required Uri module in multiple Zoho configurations. - 3832
New: [Saleforce] Support for Tooling SOAP API, including executing Apex DML statements (to be used with JS Task scripts) - 3828
Fixed: [Database Source] Issue with handling nvarchar(max) columns in SQL Server - 3824
Fixed: [Base] The first output was not preserved during the refresh, causing issues in the DFT+ . - 3830
New: [NetSuite Destination] Implemented new 'AsyncProcess' parameter for asynchronous processing. - 3821
Fixed: [Data Flow Task Plus] - a regression issue with setting scale and precision for some data types in destination components (e.g. OLEDB Destination) - 3825
New: [Hubspot] Updated to use new v3 Owners API. - 3823
Fixed: [Database Source] Design time issue when using SELECT DISTINCT clause - 3818
Fixed: [Dynamics Business Central] Missing closing bracket. - 3819

Library 2.1.102.3739 Published: Tuesday, August 27, 2024 - 05:52

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

New: [Pardot] Included 'Visitor Activity' resource. - 3978
New: [Hubspot] Included 'Form Submission' resource. - 3980
New: [BigCommerce] Implemented to use new Category endpoints. - 3977
Fixed: [ZipTask] Issue with TAR compression of files, with sizes bigger than 8GB - 3969
Fixed: [JavaScript] An ocassional error "The directory is not empty" in the post-execution cleanup. - 3960
Fixed: Transferring a file from one REST-based File Manager to another via In-memory stream variables trims data - 3967
Fixed: [Zip Task] A regression issue with Zip AES decompressing. - 3962
Fixed: Various issues with renaming items in Google Drive - v2.1 - 3959
Fixed: [Composite Records] The escaping of . in names of composite outputs/inputs of components is now _ (for consistency). - 3964
Fixed: [File Transfer Task] For "Get remote file list" with REST connections, folders couldn't be excluded by "RemoteFilter" expression - 3954
Fixed: [File Transfer Task] Sometimes the selection in the File Browser didn't activate properly the OK button in the dialog. - 3952
Fixed: [File Transfer Task] Path was not always configured with the correct separator. - 3948
Fixed: [Blackbaud] Corrected Read.Result definition for 'NXT | Constituent' resource. - 3945
New: [Excel Source] Property TrimColumnNames to specify whether to remove whitespace from start/end of column names - 3931
New: [OpenAPI Import] Support for schema types with multiple references - 3935
Fixed: [Parquet] Issues with composite records supports
Fixed: [Parquet] Change the default column length for string columns to 250 - 3934
New: [Shopify] Replaced value_type with type in metafield. - 3932
Fixed: [Table Difference] Have a row for each difference among comparable rows, not just the first difference - 3923
New: Use Secure cookies to prevent vulnerabilities when using HTTP - 3925
Fixed: SpashForm always wait VS Editor in component load - v2.1 - 3922
Fixed: [REST] Increased result Id column length. - 3907
New: [Zendesk] Updated 'Organization Membership' resource to use cursor pagination. - 3904
Fixed: [Google BigQuery] Corrected expression for Job.Create action. - 3899
Fixed: [Exchange] Removed Test definition because it is not needed. - 3896
Fixed: [Database Destinatinon] Crash in dynamic flow context, in case not all input columns are used - 3894
Fixed: [JavaScript Component] Possible crash on first change of metadata - 3888
Fixed: [REST] Better handling of nil=true attributes from XML responses - 3885
Fixed: [QuickBase] Configure field names to exclude special dot (.) character. - 3880
New: JavaScript Function to return input column names - 3877

Library 2.1.101.3625 Published: Tuesday, April 23, 2024 - 11:26

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

Fixed: [FLEE] Expression editor was not highlightning properly some keywords and SSIS variables
New: [Editor] Have a distinctive highlight of SSIS variables in various places where SQL-like expressions are used - 3869
Fixed: [SendGrid] Corrected Bounce resource metadata. - 3867
New: [JavaScript] Include detailed stack trace information in dot template expressions evaluation (REST configuration) and in other contexts, as well. - 3865
New: [Preview] When previewing data in REST Source and Salesforce Source differentiate b/n NULL and empty strings - 3863
Fixed: [Base] Rework variable replacement logic in FLEE expressions (2.1) - 3861
Fixed: [WSDL] Error in addSecurityBody when using custom authentication
Fixed: [WSDL] When analyzing the types in the response, by default prefer direct child types instead of inherited types - 3857
Fixed: [REST] Resolve ""Block length does not match with its complement." issue with RestSharp" - 3843
New: [Amazon S3] Support for VPC endpoints - 3840
Fixed: [Microsoft Graph] Implemented to remove symbols from list column names... - 3845
New: [Blackbaud] Included definition for new /creditmemos API. - 3841
Fixed: [REST] Modified to ignore undefined values when handling structured fields. - 3836
New: [Blackbaud] Included additional metadata in 'Church | Gift' resource. - 3835
Fixed: [Data Flow Task Plus] - a regression issue with setting scale and precision for some data types in destination components (e.g. OLEDB Destination) - 3825
Fixed: [Zendesk] Corrected Ticket -> Search pagination. - 3814
Fixed: [Base] Registry-free process was not handled correctly. - 3800
Fixed: [JSON Source] issue with not properly quoted string in array in a DT_NEXT column (was not a valid JSON array)
Fixed: [MongoDB Source] issue with not properly quoted string in array in a DT_NEXT column (was not a valid JSON array) - 3792
New: [Microsoft Graph] Included additional definitions. - 3788
Fixed: [Hubspot] Updated default authentication scope. - 3782
Fixed: [REST] Better error handling when failing the retrieve a token via Edge web control - 3778
Fixed: [REST] Unable to handle response in Iterator.Next.Value when only Read.Result is used. - 3766
Fixed: [SSH] Previous folder restore may fail after upload. Ignore. - 3763
Fixed: [WSDL Import] Regression issue with import without a specified location - 3755
Fixed: [REST Destination] Exception "COM object that has been separated from its underlying RCW cannot be used." when processing BLOBs. - 3753
Fixed: [Square] Fix recently introduced syntax error - 3751
Fixed: [Linkedin] Fixed incorrect DoT definition. - 3743
New: [Square] Updated configuration to use the default redirect_uri . - 3736
New: [Zendesk] Updated configuration to use the default redirect_uri . - 3734
New: [REST] Display documentation about token parameters when retrieving a new token - 3732
New: [Smartsheet] Updated configuration to use the default redirect_uri . - 3729
New: [WSDL] Support for specifying namespaces of parameters in READ operations - 3726
New: [MailChimp] Updated configuration to use the default redirect_uri . - 3721
Fixed: [Base] Prevent sending excessive runtime telemetry - 3699
Fixed: [REST] Incorrect processing of request Url definition when Service element defined. - 3696

Library 2.2.100.3575 Published: Wednesday, February 14, 2024 - 03:28

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

New: [Salesforce Source] In Bulk read mode, don't load the web response stream in memory. - 3791
Fixed: [Zendesk] Corrected Ticket -> Search pagination. - 3814
New: [Jira] Implemented OAuth2 authentication. - 3813
New: Zoho Campaigns REST Configuration - 3785
New: [PureCloud] Additional definitions and enhancements. - 3811
Fixed: [OpenAPI Import] Improve error message when the selected document is not an OpenAPI spec. - 3810
Fixed: [REST] Incorrect detection of complex field when handling Set definition. - 3808
Fixed: [Zoho] Updated configurations to support different regions. - 3803
Fixed: [CZSSISPlus] Registry-free process was not handled correctly. - 3799
Fixed: [Install] CZSSISPlus.2022.dll module was not registered for VS 2022. - 3797
Fixed: [Microsoft Graph] 'Site | List Item' metadata has to be updated after... - 3796
New: [Procore] Updated with latest enhancements. - 3795

Library 2.2.1.3550 Published: Wednesday, January 31, 2024 - 16:33

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

New: [ASN.1 Source] Introduced a component to read BER/CER/DER encoded data - 3588
Fixed: [JSON Source] Issue with not properly quoted string in array in a DT_NEXT column (was not a valid JSON array)
Fixed: [MongoDB Source] Ussue with not properly quoted string in array in a DT_NEXT column (was not a valid JSON array) - 3792
New: [Dropbox] Dropbox refuses to approve COZYROC's production application. Defined parameters for customer to be able to enter his own application identifier. - 3783
New: [REST] Configuration for 'Google Search Console' service. - 3790
New: [Microsoft Graph] Included additional definitions. - 3788
New: [EDI] Support for streaming (i.e. not using a physical file) in EDI Source and EDI Destination - 3774
New: [REST] Configuration for 'Snowflake' service. - 3786
Fixed: [Hubspot] Updated default authentication scope. - 3782
New: [JSON Source] Support for streaming via an Object Variable - 3770
Fixed: [WSDL] Restore backwards compatibility with configurations that use namespace - 3780
New: [REST] Configuration for 'Azure Files' service.
Fixed: [REST] Modified request parameters setup to ensure if an object is provided as input to check if it has members (not Date, ArrayBuffer, Stream, etc) - 3710
Fixed: [REST] Better error handling when failing the retrieve a token via Edge web control - 3778
New: [REST] In the custom configuration editor offer separate templates for the three types of OAuth 2.0 flows - 3775
Fixed: [REST] Cleanup to match default OAuth2 template. - 3777
Fixed: [EDI Source] Include sequence terminator even for empty sequences. - 3758
Fixed: [Act-On] Updated OAuth authentication to follow default template. - 3773
Fixed: [REST] Removed functions from Azure Storage authentication module that are not needed. - 3772
New: [Database Source] Read data from popular database via ADO.NET, OLE DB and ODBC providers - 3719
Fixed: [REST] Unable to handle response in Iterator.Next.Value when only Read.Result is used. - 3766
New: [Blackbaud] Defined 'School | Student Schedule' resource. - 3765
Fixed: [SSH] Previous folder restore may fail after upload. Ignore. - 3763
Fixed: [REST] Modified Test element not to require Url attribute definition. - 3762
Fixed: [Salesforce CRM Analytics] OAuth2 authentication cleanup. - 3761
New: [Procore] Included latest API enhancements. - 3760
Fixed: [Klaviyo] Removed deprecated endpoints - 3759
New: [REST] Preserve new lines in parameter values in REST Source and REST Destination editors - 3639
Fixed: [GraphQL] Modified to define fields with undefined type metadata as string. - 3757
Fixed: [WSDL Import] Regression issue with import without a specified location - 3755
Fixed [REST Destination] Exception "COM object that has been separated from its underlying RCW cannot be used." when processing BLOBs. - 3753
New: [REST] Configuration for FHIR services. - 3457
Fixed: [Square] Fix a recently introduced syntax error - 3751
New: [Slack] Updated to use new OAuth2 v2.0 authentication. - 3750
Fixed: [Linkedin] Fixed incorrect DoT definition. - 3743
New: [YouTube] Updated configuration to follow default OAuth2 template. - 3746
New: [Qualtrics] Updated configuration to use the default redirect_uri . - 3745
New: [Oracle Eloqua] Updated configuration to use the default redirect_uri . - 3744
Fixed: [Box] Updated configuration to use user-configured redirect address for... - 3741
Fixed: [monday] Included API version. - 3740
Fixed: [General] Passwords with semicolons got corrupted after closing a Connection Manager Editor - 3731
New: [Square] Updated configuration to use the default redirect_uri . - 3736
Fixed: [NetSuite] Corrected to provide client id/secret for creating the access token. - 3737
New: [ArcGIS Feature] Updated configuration to use the default redirect_uri . - 3735
New: [Zendesk] Updated configuration to use the default redirect_uri . - 3734
New: [REST] Display documentation about token parameters when retrieving a new token - 3732
New: [Smartsheet] Updated configuration to use the default redirect_uri . - 3729
New: [PureCloud] Included OAuth authentication. - 3727
Removed: Wunderlist service no longer exists. - 3723
Removed: Parature service no longer exists. - 3722
New: [MailChimp] Updated configuration to use the default redirect_uri . - 3721
New: [Blackbaud] Included definition for 'Financial | Receipt' resource. - 3720
New: [General] Preserve stack trace independent of SQL Server targeting - 3718
New: [Tableau Destination] Support for UPDATE and DELETE in a .hyper file. - 3716
New: [WSDL] Support for specifying namespaces of parameters in READ operations - 3670
New: [REST Source] Display "Batch Size" in editor only if the endpoint supports paging with batch size - 3717
New: [Visual Studio 2022] Support for SQL Server 2016 (with SSIS Project 1.2) - 3714
Fixed: [REST Source] Skip unnecessary refreshing of component's metadata
Fixed: [REST Source] Don't show the "More" row in Preview grid if the initial request fails - 3709
Fixed: [Amazon S3] Don't use batchSize for max-keys, as it interferes with paging of the result object list - 3711
New: [REST] Add generic OData support. - 3569

Library 2.2.1.3465 Published: Monday, November 13, 2023 - 10:45

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

New: [REST] Configuration for Amazon Simple Queue Service.
New: [REST] Configuration for Google Cloud Monitoring.
New: [REST] Configuration for Gravity Forms.
New: [REST] Configuration for Salesforce CRM Analytics.
Fixed: [REST] Incorrect processing of request Url definition when Service element defined. - 3696
Fixed: [Wrike] Corrected UI editors. - 3694
New: [ADP] Included definition to retrieve single Worker resource. - 3695
New: [Kafka] Add support for retrieval and sending of message header - 3671
New: [Procore] Updated with latest features. - 3692
New: [REST Connection Manager] Better warning message when placeholder(s) in server URL is not configured. - 3690
New: [REST Source] Support for previewing data beyond the first page
Fixed: [REST Source] When fetching data for previewing, use the current Batch Size in the UI (not the previously saved one) - 3681
New: [REST Connection Manager] Easier selection of configuration - 3686

Library 2.1.100.3448 Published: Wednesday, November 1, 2023 - 09:13

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

Fixed: [REST] Evaluate definitions wrong result in parallel execution - 3691
Fixed: [OpenAPI Import] crash when no schema is specified for an array element - 3682
Fixed: [Microsoft Graph] Modified to configure more user-friendly list columns - 3673
New: [REST] Included resource name in list editor caching process. - 3672
Fixed: [ADP] Remove ZERO WIDTH SPACE (U+200B) characters. - 3666
New: [OpenAPI Import] Automatically configure the processing of endpoint responses that are not simply arrays - 3663
Fixed: [Power BI] tenant parameter was not used during OAuth token generation. - 3127
Fixed: [Trello] Updates in CardT template. - 3655
Fixed: [JavaScript] A deadlock occurring in some rare situations - 3653
Fixed: [WSDL Import] Issue when referencing an external XSD with importelement - 3644
Fixed: [OpenAPI Import] Error when path ends with a slash - 3646
Fixed: [PureCloud] Fixes in 'Datatable Row' resource. - 3645
Fixed: [Google BigQuery] DATETIME field type was not handled properly. - 3642
Fixed: [OpenAPI Import] Allow the import to continue if there are no fatal errors. - 3638
Fixed: [REST] Minor fixes in different REST configurations. - 3637, 3631
New: [REST Configuration Editor] Show warnings for circular references in template fields
New: [Open API Import] Sort endpoints in the Import Wizard by path (easier finding) - 3625
Fixed: [SugarCRM] Various fixes. - 3630
Fixed: [Shopify] Service reports next page marker inconsistently with different case. - 3626
Fixed: [REST] In parameters editor be able to use the editor popup for existing parameters, not just new ones. - 3624
Fixed: [QuickBase] Failure in data query. - 3617
Fixed: [AMQP Connection] Support for TLS 1.2 - 3611
New: [Parquet Source] Improve support for timespan values - 3613
New: [OpenAPI Import] Various small improvements
New: [WSDL Import] Various small improvements - 3489
Fixed: [File Transfer Task] Specifying only wildcard for the Remote parameter (no folder) caused failure when using 'Receive Action'. - 3606
Fixed: [OpenAir] Included UserWorkschedule type. - 3604
Fixed: [WSDL Import] Various small issues - 3602
New: [Kafka] Add support for logging
New: [Kafka] Update Conluent.Kafka client to 2.1.1 - 3605
New: [JSON Destination] Support for storing result into a stream Variable" - 3592
New: [XML Destination] UI for type and variable - 3591
Fixed: [REST] Modified not to use Path methods which are unable to handle path containing double quote (") characters. - 3585
New: [JSON Destination] Improve behavior in dynamic data flows by outputting all upstream columns - 3586
New: [Zendesk] Included cursor pagination for Ticket and User resources. - 3589
New: [Microsoft Graph] Support for delta endpoint in Message resource. - 3582
Fixed: [Amazon S3] Upload from stream variable - 3576
New: [Base] Implemented to set transfer stream name from configured storage variable description. - 3578
New: [Copper] Implemented to configure array for parameters with suffix _ids. - 3573
Fixed: [Google Cloud Storage] Use more appropriate endpoint for testing connectivity for 'Service Account' - 3095
New: [WSDL Import] Improve error message in case referenced element is missing - 3567
Fixed: [File Transfer Task] Incorrect initialization of output stream. - 3564
Fixed: [General] Some destination editors crashed when displaying a tooltip if the column name contained special symbols like {} - 3522
Fixed: [ArcGIS Feature] Various improvements. - 3557
Fixed: [NetSuite Source] High-DPI scaling in Query designer
Fixed: [Dynamics GP] High-DPI scaling in Query designer
Fixed: [QuickBooks Source] High-DPI scaling in Query designer - 3523
Fixed: [Kafka] Issues with incorrect and incomplete list of SSL-related properties - 3553
Fixed: [SugarCRM] Made client_secret authentication parameter optional. - 3549
Fixed: [Hubspot] Failed to upload file using 'File Transfer Task'. Other... - 3547
Fixed: [Sage Intacct] Corrected metadata in 'Attachment Legacy' resource. - 3546
Fixed: [KRONOS] Defined hr_customFields and pay_info fields under Employee resource. - 3543
New: [File Transfer Task] Support for setting file permission in SFTP after upload - 3540
Fixed: [Base] Modified LoadSimpleKeyValueList function to use case-insensitive dictionary. - 3539
Fixed: [Zendesk] Fixes in 'Ticket Field Option'. - 3529
Fixed: [Microsoft Graph] Removed wrong definitions. - 3528
Fixed: [Zoho CRM 2] Removed wrong definition. - 3531
Fixed: [Smartsheet] Removed wrong definition. - 3530
New: [Parquet] Support for "date" and "time" fields
Fixed: [Parquet] Rename "datetimeoffset" type to "timestamp"
New: [Parquet Destination] Accept other input data types besides DT_DBTIMESTAMPOFFSET when outputting timestamps - 3499
New: [WSDL/SOAP] Support for more granular (field-level) namespaces in SOAP services - 3518
Fixed: [REST Source] Crash when handling in a dynamic data flow consequtive resources with a single and then multiple outputs. - 3512
Fixed: [File Transfer Task] Regression issue with receiving "Access Denied" error, in case SFTP server doesn't support changing directories - 3513

Library 2.2.1.3445 Published: Tuesday, October 31, 2023 - 13:09

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

Fixed: [REST] Structured field transform accidentally overwrote other values. - 3689
Fixed: [REST] Evaluate definitions wrong result in parallel execution - 3688
Fixed: [Oracle Cloud Object Storage] Error with an empty bucket - 3687
New: [Excel] Updated with latest backend module. - 3684
Fixed: [OpenAPI Import] crash when no schema is specified for an array element - 3682
New: [REST] Enable filtering endpoints in OpenAPI import and operations in WSDL import - 3659
New: [REST] KnowBe4 configuration.
New: [REST] Klaviyo configuration.
New: [REST] Prestashop configuration.
New: [REST] Amazon DynamoDB configuration - 3654
New: [Google Analytics] Support for Google Analytics Admin API. - 3680
New: [monday] Modified to use new GraphQL module. - 3679
New: [REST] Google Dataplex configuration. - 3678
Fixed: [Microsoft Graph] Modified to configure more user-friendly list column... - 3673
New: [REST] Included resource name in list editor caching process. - 3672
New: [OpenAPI Import] Improve resource fields detection in some cases - 3662
New: [OpenAir] Updated with latest SOAP proxy. - 3669
Fixed: [ADP] Remove ZERO WIDTH SPACE (U+200B) characters. - 3666
New: [OpenAPI Import] Automatically configure the processing of endpoint responses that are not simply arrays - 3663
Fixed: [Marketo] Included definition for Lead.Read filterType parameter. - 3661
Fixed: [Package Connection Manager] Issue when executing against SQL Server 2022 - 3510
Fixed: [Oracle Eloqua] Included replacement with curly braces for syncActions parameter expression. - 3657
Fixed: [Trello] Updates in CardT template. - 3655
Fixed: [Azure Blob Storage][Oracle Cloud Object Storage] Upload of stream with unknown length - 3651
Fixed: [WSDL Import] Issue when referencing an external XSD with importelement - 3644
Fixed: [JavaScript] A deadlock ocurring in some rare situations - 3647
Fixed: [OpenAPI Import] Error when path ends with a slash - 3646
Fixed: [PureCloud] Fixes in 'Datatable Row' resource. - 3645
Fixed: [Google BigQuery] DATETIME field type was not handled properly. - 3642
Fixed: [OpenAPI Import] Allow the import to continue if there are no fatal errors. - 3638
Fixed: [REST] Minor fixes in different configurations. - 3637, 3636, 3633, 3631
New: [REST Configuration Editor] Show warnings for circular references in template fields
New: [Open API Import] Sort endpoints in the Import Wizard by path (easier finding) - 3625
Fixed: [SugarCRM] Various fixes. - 3630
New: [Procore] Updated with latest changes. - 3629
Fixed: [Shopify] Service reports next page marker inconsistently with different case. - 3626
New: [ServiceTitan] Included special handling for statuses parameter in Invoice.Read. - 3627
Fixed: [REST] In parameters editor be able to use the editor popup for existing parameters, not just new ones. - 3622
Fixed: [Text Editor] Regression issue with cursor not catching up quickly when typing - 3621
Fixed: [GraphQL] Minor fixes. - 3623
New: [File Transfer Task] Included Box in the list of available connection types. - 3620
Fixed: [QuickBase] Failure in data query. - 3617
Fixed: [REST] Tweak GraphQL template to remove the "Default" for "variables" - 3616

Library 2.2.1.3374 Published: Tuesday, September 26, 2023 - 12:56

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

Fixed: [AMQP Connection] Support for TLS 1.2 - 3611
Fixed: [Oracle Cloud Object Storage] Reading from "Object" resource - 3614
New: [Base] "Add support for subscribing to .NET events in JavaScript" - 3612
New: [REST] Configuration for Expensify service.
New: [REST] Configuration for Zoho Books service.
New: [REST] Configuration for Wrike service.
New: [Parquet Source] Improve support for timespan values - 3603
New: [OpenAPI Import] Various small improvements
New: [WSDL Import] Various small improvements - 3489
Fixed: [File Transfer Task] Specifying only wildcard for the Remote parameter (no folder) caused failure when using 'Receive Action' - 3606
Fixed: [OpenAir] Included UserWorkschedule type. - 3604
Fixed: [WSDL Import] Various small issues - 3602
Fixed: [REST] Set BodyRequired=false default for Delete action. - 3600
Fixed: [REST] Corrected BodyRequired attribute definition to make it possible to override. - 3598
New: [JSON Destination] Store result into a stream Variable" - 3592
New: [Kafka] Add support for logging
New: [Kafka] Update Conluent.Kafka client to 2.1.1 - 3572
New: [XML Destination] UI for type and variable - 3591
Fixed: [REST] Modified not to use Path methods which are unable to handle path containing double quote (") characters. - 3585
New: [Zendesk] Included cursor pagination for Ticket and User resources. - 3589
New: [Procore] Updated with latest API changes. - 3584

Library 2.2.1.3341 Published: Thursday, August 31, 2023 - 04:31

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

New: [Microsoft Graph] Support for delta endpoint in Message resource. - 3582
New: [JSON Destination] Improve behavior in dynamic data flows by outputting all upstream columns - 3541
Fixed: [Oracle Eloqua] Various fixes. - 3580
Fixed: [Amazon S3] Upload from Zip Task variable - 3576
New: [Base] Implemented to set transfer stream name from configured storage variable description. - 3578
New: [Copper] Implemented to configure array for parameters with suffix _ids. - 3573
New: [Procore] New configuration. - 3574
New: [Facebook Business] New configuration. - 3575
New: [NetSuite] Updated web service proxy to version v2023.1 version. - 3570
New: [WSDL Import] Improve error message in case referenced element is missing - 3567
Fixed: [File Transfer Task] Incorrect initialization of output stream may result in failure. - 3564
Fixed: [General] Some destination editors crashed when displaying a tooltip if the column name contained special symbols like {} - 3522
Fixed: [ArcGIS Feature] Various improvements. - 3557
Fixed: [NetSuite Source] High-DPI scaling in Query designer
Fixed: [Dynamics GP] High-DPI scaling in Query designer
Fixed: [QuickBooks Source] High-DPI scaling in Query designer - 3523
Fixed: [Kafka] Issues with incorrect and incomplete list of SSL-related properties - 3553
Fixed: "REST Source/Destination Parameters grid custom Editor UI not shown" - 3554
New: [JavaScript] Support for more ECMAScript 6 features (classes, let, const, promises)
Fixed: [JavaScript] Small fixes and performance improvements - 3524
New: [FTPS][SSH] Updated to use latest backend modules. - 3552
Fixed: [Hubspot] Failed to upload file using 'File Transfer Task'. - 3547
Fixed: [SugarCRM] Made client_secret authentication parameter optional. - 3545
Fixed: [Sage Intacct] Corrected metadata in 'Attachment Legacy' resource. - 3546
New: [File Transfer Task] Support for setting file permission in SFTP after upload - 3540
New: "Tableau Source (based on Hyper API)" - 3436
New : [JS Scripts] Improve editor for JS scripts parameters that contain JavaScript code
Fixed: [Derived Column Plus] Fix an issue with double slashes - 3515
Fixed: [Base] Modified LoadSimpleKeyValueList function to use case-insensitive dictionary. - 3538
Fixed: [Canvas LMS] Various fixes. - 3525
Fixed: [Zendesk] Fixes in 'Ticket Field Option'. - 3529
Fixed: [Microsoft Graph] Removed wrong definitions. - 3528
New: Use automatic Product Version for the MSI and include the minor build - 3521
New: [Parquet] Support for "date" and "time" fields
Fixed: [Parquet] Rename "datetimeoffset" type to "timestamp"
New: [Parquet Destination] Accept other input data types besides DT_DBTIMESTAMPOFFSET when outputting timestamps - 3499
Fixed: [Google Analytics] Implemented to limit dimension length to prevent data retrieve failure. - 3519
Fixed: [REST Source] An exception due to race condition. - 3469
Fixed: [REST Source] Crash when handling in a dynamic data flow consequtive resources with a single and then multiple outputs. - 3512
New: [WSDL/SOAP] Support for more granular (field-level) namespaces in SOAP services - 3471
Fixed: [File Transfer Task] Regression issue with receiving "Access Denied" error, in case SFTP server doesn't support changing directories - 3513

Library 2.2.1.3269 Published: Thursday, July 13, 2023 - 04:34

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

Library 2.1.100.3271 Published: Thursday, July 13, 2023 - 04:19

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

Fixed: [Base] Code that serialized script parameters into variables failed when project parameters were prefixed with underscore (_) character - 3505
Fixed: [JSON Destination] Issue with opening the Editor before specifying the JSON sample - 3500
Fixed: [Data Flow Task Plus] Remove special THUNK_COLUMN if included in 'Data Conversion' component - 3496
Fixed: [Smartsheet] When clear parameter was configured, the destination sheet was incorrectly reset during design time - 3490
Fixed: [REST] WebView2 module crash when trying to handle localhost hookup. - 3487
Fixed: [Sage Intacct] Included definition for create_sotransaction action.... - 3479
New: [Hubspot] Increased Contact resource action batch limit to 1000. - 3480
New: [LDAP Destination] Support for changing user passwords in Active Directory (via the "unicodePwd" field)
Fixed: [LDAP Destination] An issue with DT_GUID and DT_DBTIMESTAMP values
New: [LDAP Destination] Include complete error details in error messages - 3466
New: [LDAP Destination] Support for renaming objects (via updating their CN) - 3157
Fixed: [Base] Stream abstraction over BlobColumn is no longer attached to current buffer row. - 3476
Fixed: [REST] Failed to retrieve complex structured fields. - 3474
Fixed: [Parallel Loop Task] Error when executing parent->child package with parameters with coinciding names - 3472
Fixed: [Salesforce Source] Got NULL when an output column names differs from an external column name - 3464
Fixed: [REST] When preparing the payload for an action, preserve the order of the defined fields - 3460
New: [Parquet Source] Remove the Schema property and make the component more convenient to use in dynamic data flows - 3427

Library 2.1.100.3226 Published: Wednesday, May 24, 2023 - 05:16

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

Fixed: [PDF Source] Exception "Dictionary entry value is not indirect object." when loading a PDF document - 3389
New: [Blackbaud] Definition for school advisory API - 3450
Fixed: [QuickBooks Online] Correction for report Total composite. - 3447
New: [QuickBooks Online] Defined Report selector. - 3441
Fixed: [Power BI] Additional improvements. - 3440
New: [XML Destination] Support for importing XSDs with complex type extension
New: [XML Destination] Support for importing XSDs with repeatable group - 3419
Fixed: [REST Connection] Issues with property TokenStore
Fixed: [Exchange Connection] Issues with property ServerUser
Fixed: [SMTP Connection] Issues with property ServerUser
Fixed: [IMAP Connection] Issues with property ServerUser - 3437
Fixed: [Amazon S3] Improvements in configuration (2.1) - 3435
New: [NetSuite] Implemented to include name attribute in list reference fields output. - 3430
Fixed: [Install] Incorrect parent install folder for 64bit modules. - 3429
New: [QuickBooks Desktop] Enable TLS1.2 in QBConnector.exe - 3420
Fixed: [Google Analytics] Implemented report metadata initialization not to fail... - 3424
New: [Sage Intacct] Modified to select fields up to three levels deep. - 3422
New: [Database Destination] Oracle OLE DB bulk support - 3421
New: [REST Connection] UserAgent property - 3412
New: [Salesforce Source] Support for compound field Address - 3402
Fixed: [Kafka] Support semicolons in password (useful for connecting to Azure Event Hub) - 3414
Fixed: [REST Connection] Resolve "WSDL Importer page not fully visible in some high-DPI scenarios" - 3410
Fixed: [Blackbaud] Improved School resources pagination definition. - 3407
Fixed: [Amazon S3] Support for names containing + symbol - 3405
Fixed: [Dynamics Business Central] Additional fixes around the support for navigation properties. - 3398
Fixed: [General] Columns were not displayed in Error Output page of source components, when they were removed and added again - 3394
Fixed: [Destinations] Exception when opening a Component Editor when targeting SQL Server 2022 - 3388
Fixed: [Zendesk] Removed pagination in 'Ticket Field Option' resource. - 3383

Library 2.1.100.3152 Published: Wednesday, March 22, 2023 - 18:44

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

New: [Blackbaud] Included teachers definition in 'School | Section' resource. - 3378
New: [REST] Implemented JS-friendly method to get list of available resources. - 3373
Fixed: [XML Destination] Nested groups support. - 3369
Fixed: [General] Prevent a license check failure if license expires just after execution has started - 3372
Fixed: [Amazon S3] "Inefficient upload of file. - 3356
Fixed: [Microsoft Dataverse] Field's metadata caching was not updated after 'FetchXml' parameter modification. - 3361
Fixed: [Power BI] Various fixes and enhancements. - 3359
New: [Dynamics Business Central] Support for navigation properties. - 3357
New: [REST Connection] "New property "RequestsPerMinute". - 3349
Fixed: [Parquet Source] Upgrade SDK to Parquet.Net 3.10.0 to fix an issue with incorrect reading of some parquet files. - 3348
Fixed: [Blackbaud] Pagination never ends for School resources. - 3350
Fixed: [REST] Modified to skip composite fields when processing at the root. - 3342
Fixed: [Zendesk] Modified id field definition to accommodate larger identifiers. - 3337
Fixed: [Sage Intacct] Incorrect caching of all object relationship fields, instead of only loading from the list selected by the customer. - 3338
New: [Microsoft Graph] Included definition to retrieve Message from shared folder. - 3333
Fixed: [JavaScript] Optimized COM object release. - 3331
Fixed: [General] Error with SQL Server 2022 support, related to interface type 'CozyRoc.SqlServer.SSIS.Patch.IDTSBufferR' (affects multiple components) - 3328
Fixed: [XML Destination] Exception when importing XSD with "union" of base types
Fixed: [XML Destination] Exception when using the component in a loop. - 3316
Fixed: [JavaScript Component] Design-time error when selecting/modifying a script in case the main input has different properties from the existing one. - 3321
New: [General] Customize JavaScript syntax highlighter. - 3314
New: [General] "Tune how and which column differences are displayed in the mapping pages." - 3318
New: [REST] Support for updating a token in a Database storage. - 3317
New: [XML Destination] Use the standard SSIS+ 250 chars length for external DT_WSTR columns, instead of 50 (the change doesn't affect the runtime behavior) - 3312
Fixed: [Google Analytics] Multiple ranges report retrieve failed. - 3307
Fixed: [EDI Source] Configuration's delimiters were accidentally overwritten. - 3303
Fixed: [REST Source] Non-enumerable parameters appeared in the request during the fields metadata initialization. - 3301
Fixed: [REST Destination] Non-enumerable parameters appeared in the request during the fields metadata initialization. - 3301
New: [XML Destination] Auto-conversion from string to date values.
New: [XML Destination] Quickly navigate from mapping to model by double-click.
New: [XML Destination] Support for XSD "group" element - 3251
Fixed: [REST] According to OAuth1 specification the signature has to be generated for all lower-case 'Base String URI'. - 3293

Library 2.1.100.3064 Published: Sunday, February 12, 2023 - 06:37

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

Fixed: [SurveyMonkey] Fix incorrect page editor UI. - 3288
Fixed: [REST] Regular fields were incorrectly filtered out from action payload. - 3285
Fixed: [VS Extension] Fixed default icons of connection managers - 3276
New: [Licensing] The machine ID for ADF SSIS IR now explicitly contains the number of nodes - 3273
Fixed: [Amazon S3 REST] - "The path is not of a legal form." error during listing items in a bucket - 3252
Fixed: [REST] When logging is enabled, attempting to log the request content caused a crash - 3266
New: [Blackbaud] Modified to make the Test address to be customizable. - 3268
New: [Hubspot] Included additional definitions. - 3257
Fixed: [VS Extension] Show SSDT incompatibility warning just once - 3253
Fixed: [REST] Incorrect handling of requests containing Query parameters in OAuth1 module. - 3247
Fixed: [JavaScript] Prevent having temporary JS script files left out after execution of JS Component and JS Task. - 3238
New: [XML Destination] Performance improvements - 3233
Fixed: [Base] Restored a needed entry. - 3242
Fixed: [RabbitMQ] Hanging package executions when package is run as a part of a SQL Agent jobs (i.e. with ISServer.exe) - 3117
Fixed: [Excel Source] Processing of columns with type different from string... - 3231
Fixed: [Telemetry] When telemetry is turned off, skip unnecessary WMI queries - 3227
New: [Blackbaud] Replaced deprecated 'School | Dorm Resident' resource with... - 3224
New: [XML Destination] Support for self-referencing elements, attribute group references and simple type restrictions. - 3217
New: [Base] Updated with the official SQL 2022 and SSDT 4.3 modules. - 3216
New: [Base] Updated to use latest SSDT 4.3 manifest definitions. - 3213
Fixed: [REST] Modified to interpret empty string input for composite field as undefined. - 3207
New: [XML Destination] Simple type references support. Support choice located in Complex type. - 3206
New: [Shopify] Defined 'Discount | Price Rule' and 'Discount | Discount Code' resources. - 3203
Fixed: [Dynamics Business Central] Create/Update actions failed because there is... - 3201
Fixed: [Parquet Source] Crash when reading an empty data page
Fixed: [Parquet Source] Performance issue with "string" and "byte array" columns
Fixed: [Parquet Source] Streaming not properly working (big files consumed excessive memory) - 3195
New: [Zuora] Support for 'Data Query' functionality. - 3192
Fixed: [Google BigQuery] Incorrect processing for timeout parameter when... - 3185
New: [Zip Task] Support for decompressing ZIP files using deflate64 algorithm - 3132
Fixed: [Hubspot] Removed depreciated scope. - 3181
Fixed: [Smartsheet] Implemented improved handling of numeric input values when writing data. - 3177
New: [REST] Included ability to instantiate REST connection. - 3173
New: [XML Destination] Support for `` element when importing model from XSD. - 3139
Fixed: [XML Destination] Better default Scale for decimal columns. - 3169
Fixed: [REST] The non-enumerable parameters were incorrectly used in fields... - 3165
Fixed: [VS Extension] Invoking GetCanonicalName unmanaged function in earlier... - 3162
Fixed: [Zuora] Typo fix. - 3152
Fixed: [Formstack] Corrected portal avatar retrieval. - 3151
Fixed: [ADP] Fix in getActionData function. - 3145
Fixed: [Basecamp] Incorrect Question resource Name definition. - 3144
Fixed: [Sage Intacct] Issue when XML response returned no child data rows. - 3140
Fixed: [Message Queue Task Plus] Issue with the task after changing target version. - 3137
Fixed: [Hubspot] Updated scope parameter to match the scopes configured for the application. - 3134
New: [PDF Source] SkipIncompleteRows property to handle content with unexpected number of column values that's incorrectly recognized to be within a table and thus causing a runtime crash. - 3131
Fixed: [ActiveCampaign] Action payload not sent as body. - 3123
Fixed: [Hubspot] Modified to use the new Hubspot OAuth scope definitions. - 3120
New: [Amazon Athena] Modified to use region-specific authentication Test host address. - 3118
New: [Microsoft Graph] Defined Prompt parameter. - 3111

Library 2.1.100.2882 Published: Friday, October 14, 2022 - 04:44

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

New: [Kafka Connection] Support for KeyStorePassphrase, TrustStoreLocation and TrustStorePassphrase properties - 3104
New: [REST] More flexible Amazon authentication module (to support Amazon Selling Partner API) - 3059
New: [General] Instead of sending e-mail to support, open the page for submitting a new SSIS+ ticket - 3094
New: [XML Destination] Support for external XSD references when initializing the document model.
New: [XML Destination] Support for global XSD definitions when initializing the document model.
Fixed: [XML Destination] Improve support for XML namespaces - 3061
Fixed [Parquet Destination]: Issue with skipping a record at each batch of records (batch size is determined by 'Row Group Size') - 3087
Fixed: [QuickBooks Online] Modified to use the correct Date type in the relevant fields. - 3103
Fixed: [monday] Modified not to perform pagination for resources not supporting. - 3101
Fixed: [Query] Included code to ignore blank rows. - 3096
New: [REST Editor] Enhanced "Pagination Setup" form for customizing the paging at the endpoint or the resource level. - 3073
Fixed: [VS Addon] Prevent a crash due to attempt to setup CozyRoc group in the Toolbox - 3084
Fixed: [Parquet Source][Parquet Destination] Preserve the case of headers in Parquet files - 3085
Fixed: [REST Source] Prevent memory issues due to Log Viewer - 3088
New: [VS Addon] Ability to deploy a package to COZYROC Cloud from Visual Studio - 3024
Fixed: [REST Destination] Suboptimal throughput when using more than 2 parallel threads - 3079
New: [Microsoft Graph] Included definition to retrieve Site/User/Group drive data. - 3083
Fixed: [REST] Return raw data instead of throwing exception when JSON response cannot be parsed. - 3081
Fixed: [Power BI] Modified to remove pagination definitions for resources which do not support it. - 3080
New: [REST] Included processing for ArrayBuffer input in File parameters. - 3075
Fixed: [Database Destination] Issue with SQL Server matching NULL values in Update, Upsert and Delete mode - 3025
Fixed: [REST] Fixed connection.getData method to only auto select fields where AutoSelectForRead=false - 3069
Fixed: [REST] Complex field processing failed when input field was set to null. - 3068
Fixed: [Microsoft Graph] Removed pagination for 'Teamwork | Channel' resource. - 3067
New: [Microsoft Graph] Improved handling of SharePoint list item lookup fields. - 3066
Fixed: [REST] Removed code that made it impossible to overwrite fields defined in Item definition. - 3064
Fixed: [MongoDB Destination] Support _id that's not an ObjectID - 3056
Fixed: [Shopify] Corrected two resources having the same Transaction name. - 3060
New: [BigCommerce] Modified to bulk update in Product resource. - 3058
Fixed: [Microsoft Graph] Modified the default scope because the existing scope requires very privileged access. - 3057
Fixed: [PDF Source] - Fixed a crash when processing client-provided PDF file - 3047
Fixed: [Sage Intacct] Very slow processing of large XML responses - 3042
Fixed: [EDI Source] Permit adding extra output columns - 3051
Fixed: [REST] In design-time support working of utils.getListEditor with non-standard parameters object. - 3048
Fixed: [Sage 300] Indicate that [host] is parameterizable - 3049
New: [General] Support for SQL Server 2022 (Preview) - 3030

Library 2.1.100.2829 Published: Thursday, August 4, 2022 - 11:43

64-bit (x64) SQL Server 2012-2022

32-bit (x86) SQL Server 2012-2022

New: [General] Support for SQL Server 2022 (Preview) - 3030
Fixed: [Parquet Source] Proper retrieving of file path from connection manager - 3044
Fixed: [General] Occasionally missing CozyRoc group in SSIS Toolbox - 3043
Fixed: [REST] A recent regression in FTP Browser for REST connections - 3039
Fixed: [Salesforce File] Better error message when attempting to upload a Salesforce file without choosing a library - 3040
Fixed: [File Transfer Task] - Issues with the dialog for selecting FTP/SFTP folders & files - 3035
New: [Amazon Athena] Support for data retrieve by directly specifying a Query statement. - 3038
Fixed: [BigCommerce] Missing forward slash in Url definition for Create action... - 3036
Fixed: [File Transfer Task] Regression issue with sending a file to a Unix-based SFTP servers - 3033
Fixed: [REST] Improve performance of processing of HTTP responses with XML content - 3029
Fixed: [Microsoft Dataverse] Parameters not processed when using 'Create' action. - 3032
Fixed: [QuickBooks Online] Included minorversion parameter for all web service requests. - 3028
Fixed: [Zoho Sheet] Included prompt=consent parameter for the OAuth for authorization request. - 3026
Fixed: [Zoho CRM] Corrected expression for the token expiration configuration. - 3027

Library 2.1.100.2809 Published: Thursday, June 23, 2022 - 15:52

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Fixed: [OpenAPI] Skip all read built-in verifications - 3023
New: [IMAP Connection Manager] Support for Outlook OAuth 2.0
New: [SMTP Connection Manager] Support for Outlook OAuth 2.0 - 3012
Fixed: [Zendesk] Enabled fields to be available for create in 'Organization Membership' resource. - 3019
Fixed: [REST] Improved cache reload check. - 3017
FixedL [Microsoft Dataverse] Removed the replacement of underscore characters in the resource name. - 3016
Fixed: [REST Destination] A validation issue when the component has multiple inputs and the root input has an _ in its name - 2998
Fixed: [Google Sheets] Backward compatibility fix for the handling of firstRowColumnNames parameter - 3014
New: [Shopify] Additional metadata definition. - 3013

Library 2.1.3.2798 Published: Thursday, June 9, 2022 - 16:45

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Fixed: [REST] Moved UI-related functions in a separate module. - 3010
New: [Microsoft Dataverse] Support for IgnoreNullValue, IgnoreMissingIdentifier, IgnoreUnchanged action parameters. Various other improvements. - 3009
New: [Zendesk] Improved handling of user_fields. - 3008
Fixed: [REST] Proper handling of complex fields in composites. External metadata was incomplete for fields defined completely in code. - 2997
Fixed: [Parquet] More robust handling of column mapping in source and destination. NOTE: Need to refresh metadata after upgrading. - 3001
Fixed: [Table Difference] A possible crash when input columns are included in the log output. - 3006
Fixed: [OpenAPI Import] Don't stop the import due to square brackets in identifiers (they are supported in OpenAPI v.2) - 3004
Fixed: [Parquet Destination] Handling of decimal, byte and float values - 3000
Fixed: [REST] Composite fields metadata was not extracted correctly for batch processing. - 2988

Library 2.1.3.2777 Published: Friday, May 20, 2022 - 19:39

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

New: [Microsoft Dataverse] Implemented to use navigation property information for lookup field update. - 2986
New: [XML Destination] Component for generating XML files. - 2705
Fixed: [General] Duplicated columns in asynchronous error output when metadata dependent changes are made. - 2983
Fixed: [Database Destination] Eliminate compilation warning messages. - 2982
New: [REST] Enable token retrieval via Microsoft Edge WebView2.
New: [Design-Time] The design time features in Visual Studio require .NET Framework 4.5 or later - 2972
New: [Microsoft Dataverse] Support for update picklist field with both name and code, update/upsert with alternate keys, upsert using "Duplicate Detection Rules". - 2981
Fixed: [Preview] "Input string was not in correct format." tooltip when column name contains {}. - 2979
Fixed: [REST] Streamlined and simplified parameters UI definition further. - 2978
New: [Smartsheet] Enhanced parameters UI. - 2977
Fixed: [REST] Retrieval of dependent parameter collection failed because of missing parameters reference. - 2976
Fixed: [General] Closing the components' editors with OK button may skip refreshing the metadata (if after a significant change the user has not moved to another page). - 2974
Fixed: Better handling of input columns in components with multiple inputs. - 2973
Fixed: [REST] Updated definitions of parameter editors for consistency. - 2971
Fixed: [Database Destination] "Cannot Resolve Collation Conflict" when using SQL Server and ADO.NET. - 2967
New: [Twilio] Definition for 'Message' resource. - 2969
Fixed: [Data Flow Task Plus] Issues with PDW Destination when working with Flat File Source in dynamic data flow. - 2933
Fixed: [Visual Studio Addon] In some situations "Remove Static Columns" didn't work for particular destinations components in Data Flow Task Plus. - 2914
New: [REST] Support for parameters of type "Cookie". - 2965
New: [SurveyMonkey] Enhanced parameters UI. - 2963
Fixed: [JSON Destination] "Duplicate element name" error in scenarios with multiple input columns with two dots in their name. - 2961
New: [Jira] Support for expand field when querying "Issue" resource. - 2957
Fixed: [Sage Intacct] Improve error handling. - 2958
Fixed: [Salesforce Source] a regression issue with bulk mode. - 2956
New: [Database Destination] Support DB2 running on "IBM i" operating system (ODBC and MS OLEDB). - 2915

Library 2.1.2.2739 Published: Tuesday, April 26, 2022 - 09:41

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Fixed: [JavaScript] Memory overflow error - 2952
New: [Sage Intacct] Implemented parameter to explicitly select relationship fields to read. - 2951
New: [REST] Resolve "Multiple selection list Editor for Rest Source and Destination" - 2950

Library 2.1.2.2736 Published: Monday, April 18, 2022 - 11:24

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

New: [REST] BigCommerce configuration - 2929
Fixed: [Core] SSIS Catalog package execution failures after installation on machine with SQL Server Data Tools installed. - 2945
New: [REST Editor] Editor definition enhancements. - 2944
Fixed: [REST Connection] Cannot create token for the second time. - 2943
Fixed: [Salesforce Source] Support relationships to custom objects in nested queries. - 2934
Fixed: [SharePoint Source] Do not alphabetically sort the columns. - 2939
Fixed: [Sort Plus] The memory limit (in MaxMemoryAllowed) property was not respected very strictly in various situations.
New: [Sort Plus] Added new property LoggingLevel for controlling what gets logged and MaxParallelOffloads and BlobColumnsMaxBytes properties for more precise control over memory management. - 2864
Fixed: [Data Flow Task Plus] Issue with handling of asynchronous error output in a destination component with composite data. - 2925
Fixed: [Dynamics Business Central] Modifications for on-premises service support. - 2910
Fixed: [Salesforce Source] Issue with parsing some SOQL queries with newlines - 2935
Fixed: [Typeform] Form response for text fields was not extracted properly. - 2930
New: [Tableau Destination] Add support for multi table extract hyper file. - 2926
Fixed: [MongoDB Destination][REST Destination][Fix] [MongoDB Destination][REST Destination] Included code to synchronize error output columns with main input during metadata reinitialize. Same code is already used in other destination components processing composites. - 2922
New: [Data Flow Task Plus] Implemented to report improved error messages for COM exceptions. - 2921
New: [Excel Task Plus] "Set cell" action now accepts variables of any type, not just string. - 2919
New: [Hubspot] Modified Scope parameter default to follow latest Hubspot guidelines. - 2917
New: [REST Destination] Enable extracting extra fields in error output, upon creating/updating records (via ErrorHandling.SuccessMessage definition). - 2911
Fixed: [Microsoft Dataverse] Corrected not to create records when using Update action. - 2912
Fixed: [REST Connectipn] Authorized Token Dialog storage type radio buttons HDPI scaling issue. - 2867
New: [Power BI] New configuration. - 2909
New: [IMAP Connection Manager] Support for Google OAuth 2.0
New: [SMTP Connection Manager] Support for Google OAuth 2.0 - 2904
Fixed: [Smartsheet] Configure some text/number fields - 2905
New: [Kronos] Support for global reports. - 2903

Library 2.0.101.2734 Published: Monday, April 18, 2022 - 07:23

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Fixed: [Core] SSIS Catalog package execution failures after installation on machine with SQL Server Data Tools installed. - 2948
Fixed: [SharePoint Source] Do not alphabetically sort the columns. - 2939
Fixed: [Sort Plus] The memory limit (in MaxMemoryAllowed) property was not respected very strictly in various situations.
New: [Sort Plus] Added new property LoggingLevel for controlling what gets logged and MaxParallelOffloads and BlobColumnsMaxBytes properties for more precise control over memory management. - 2864
Fixed: [Data Flow Task Plus] Issue with handling of asynchronous error output in a destination component with composite data. - 2925
Fixed: [Salesforce Source] Issue with parsing some SOQL queries with newlines. - 2936
New: Add support for multi table extract hyper file in Tableau destination. - 2926
New: [Data Flow Task Plus] Implemented to report improved error messages for COM exceptions. - 2923
Fixed: [MongoDB Destination][REST Destination][Fix] [MongoDB Destination][REST Destination] Included code to synchronize error output columns with main input during metadata reinitialize. Same code is already used in other destination components processing composites. - 2922
New: [Hubspot] Modified Scope parameter default to follow latest Hubspot guidelines. - 2917
New: [REST Destination] Enable extracting extra fields in error output, upon creating/updating records (via ErrorHandling.SuccessMessage definition). - 2911
Fixed: [Microsoft Common Data Service] Corrected not to create records when using Update action. - 2913
Fixed: [Smartsheet] Configure some text/number fields. - 2905
Fixed: [Visual Studio Addon] Missing context menu items in VS 2019. - 2898

Library 1.9.102.2735 Published: Monday, April 18, 2022 - 07:10

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Fixed: [Core] SSIS Catalog package execution failures after installation on machine with SQL Server Data Tools installed. - 2947
Fixed: [SharePoint Source] Do not alphabetically sort the columns. - 2942
Fixed: [Salesforce Source] Issue with parsing some SOQL queries with newlines. - 2937
Fixed: [Smartsheet] Configure some text/number fields. - 2905
Fixed: [Visual Studio Addon] Missing context menu items in VS 2019. - 2898
Fixed: [REST] Regression issue leading to ignoring some action. - 2882
Fixed: [REST] Do not ignore NULL fields in Set. - 2871
Fixed: [REST] Incorrect handling of text content response. - 2858
New: [Microsoft Common Data Service] Fix not to format null input for Date columns. Better error reporting for volatile actions. - 2859
Fixed: [Installer] When doing silent install on server with SQL Server 2019 and no Visual Studio, the Jurassic.v4.5.dll was not installed in GAC. - 2848
Fixed: [General] Preview in some source components editors was very slow when displaying many columns. - 2831
Fixed: [Hubspot] Fixed to be possible to update contact email. - 2817
Fixed: [REST Source] Preview page may crash when the displaying a huge number of columns. - 2811
Fixed: [ODBC] Wrong fraction seconds written when start with zero. - 2809
Fixed: [REST] Modified to apply first explicit Read templates (higher priority). - 2805
Fixed: [REST] Corrected element overwrite detection when processing Field.Item definitions. - 2802
Fixed: [Microsoft Common Data Service] Handle systemuser and team lookup fields. - 2787
Fixed: [REST] Issue with handling (-) minus, when converting from XML to JSON. - 2774
Fixed: [REST Source] an issue when opening the detailed view for an individual row from the Preview page. - 2771
Fixed: [REST] Implemented not to crash when there are no parameters configured for URL fields. - 2757
Fixed: [REST] Modified not to execute action if input set is empty after excluding special fields. - 2753
Fixed: [REST Configuration Editor] The validation of the currently edited JS module didn't allow referencing code from other JS modules. - 2750
Fixed: [REST Connection Manager] Location of current element in Custom configuration editor not fully displayed when not fitting in a single line. - 2730
Fixed: [REST] Non-enumerable parameters are now properly ignored when preparing the web request. - 2727
Fixed: [Microsoft Common Data Service] Fix for lookup fields without configured target. - 2697
Fixed: [REST] Failed authentication when connection was used in multiple parallel threads. - 2674
Fixed: [NetSuite] Missing custom fields for 'VendorCredit' record. - 2677
Fixed: [EDI Source] Escape symbol was not handled properly when multiple delimiter symbols were in use. - 2646
Fixed: [REST] Search for types in getClrType also in already loaded assemblies. - 2652
Fixed: [ArcGIS Feature] Corrected based endpoint template to follow ESRI documentation example. - 2648
Fixed: [REST Destination] Issue with configuring composite fields. - 2634
Fixed: [Data Flow Task Plus] issue with using ColumnAdded event handler when DelayValidation is False. - 2638
Fixed: [Salesforce Source] Try also without LIMIT when initializing metadata (as it's risky with row-level permissions). - 2628
Fixed: [REST] Allow setting a template field for a template field in REST Editor. - 2623
New: [Salesforce Source] Optimizations and fixes in metadata initialization. - 2616
Fixed: [Smartsheet] Implemented proper handling for text/number fields. - 2613
Fixed: [Microsoft Common Data Service] Modified to enable for update child entities. Those entities are assumed to be possible to modify. - 2611
Fixed: [REST] Issue with processing JSON with numbers expressed in scientific notation, where the second part starts with a zero (e.g. -7E-05). - 2593
Fixed: [Data Flow Task Plus] Failure to process with not mapped column definition and specified mandatory list. - 2586
Fixed: [Microsoft Common Data Service] Issues with lookup type fields. - 2576

Library 2.1.2.2686 Published: Monday, March 7, 2022 - 04:02

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Fixed: [Database Destination] Proper handling of DT_DBTIME2 and DT_DBTIMESTAMPOFFSET input column types when using OLE DB driver.
Fixed: [LDAP] In Active Directory attributes from auxiliary classes were missing in object metadata (e.g. sAMAccountName missing in user).
Fixed: [Microsoft Dataverse] Lookup fields reset.
Fixed: [REST] Do not ignore NULL fields in Set.
Fixed: [REST] Encrypt additional parameters in authentication token.
Fixed: [REST] Fix XML string formatting in WSDL import.
Fixed: [REST] Regression issue leading to ignoring some action.
New: [GoToWebinar] Client Id/Secret for authentication token are now configurable.
New: [Google BigQuery] Implemented enhanced configuration for various parameters.
New: [Installer] Eliminate dependency issue, related to Microsoft.Diagnostics.Tracing.EventSource.dll occasionally removed from GAC.
New: [Installer] Simplify deployment of Sage.SData.Client.35.dll and Jurassic DLLs.
New: [JSON Source] Support parsing of date values in case the output column has been manually changed to a date one.
New: [JavaScript Component] Support for dynamic data flows.
New: [Linkedin] Definition for 'Page Statistic' resource.
New: [Microsoft Dataverse] Support for attributes alias in FetchXml.
New: [OFTP Connection Manager] Introduced a connection manager for Odette File Transfer Protocol.
New: [REST Destination] Support for parallel writes via a new property "MaxParallelThreads".
New: [SendGrid] Updated 'Single Send' resource metadata.
New: [Shopify] Defined additional resources.
New: [Visual Studio Addon] A new context menu item "Analyze columns usage..." for Data Flow Task to remove unused outputs and columns.

Library 2.0.101.2677 Published: Tuesday, March 1, 2022 - 05:29

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Fixed: [Database Destination] Proper handling of DT_DBTIME2 and DT_DBTIMESTAMPOFFSET input column types when using OLE DB driver.
Fixed: [General] Preview in some source components editors was very slow when displaying many columns.
Fixed: [Installer] When doing silent install on server with SQL Server 2019 and no Visual Studio, the Jurassic.v4.5.dll was not installed in GAC.
Fixed: [JavaScript] Don't wrap undefined and null in utils.ensureArray function.
Fixed: [LDAP Destination] Properly handle input columns of type DT_TEXT/DT_NTEXT.
Fixed: [Microsoft Common Data Service] Lookup fields reset.
Fixed: [REST] Additional conditions when action request has to be made.
Fixed: [REST] Do not ignore NULL fields in Set.
Fixed: [REST] Incorrect handling of text content response.
New: [Installer] Eliminate dependency issue, related to Microsoft.Diagnostics.Tracing.EventSource.dll occasionally removed from GAC.
New: [JSON Source] Support parsing of date values in case the output column has been manually changed to a date one.
New: [Microsoft Common Data Service] Fix not to format null input for Date.

Library 2.1.2.2651 Published: Saturday, February 12, 2022 - 06:03

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Fixed: [General] Preview in some source components editors was very slow when displaying many columns.
Fixed: [Installer] Jurassic.v4.5.dll was not installed in GAC on servers with SQL Server 2019.
Fixed: [LDAP Destination] Properly handle input columns of type DT_TEXT/DT_NTEXT.
Fixed: [REST Connection Manager] A regression with not being able to browse to a file (e.g. in Google BigQuery "Service Account" authentication).
Fixed: [REST] Don't wrap undefined and null in utils.ensureArray function.
Fixed: [REST] Incorrect handling of text content response.
New: [Blackbaud] Support for reading 'School | User' using new list id API.
New: [Capsule CRM] New configuration.
New: [Excel] Use latest FlexCel 7.14.0.0 library version.
New: [File Transfer Task] When creating a new connection, display the supported list of REST configurations to enable quicker selection.
New: [Google Cloud Storage] New configuration.
New: [Microsoft Dataverse] Defined separate components for lookup fields.
New: [Multiple] More detailed logging in several destination components.
New: [REST Config Editor] Display Editor of user defined property.
New: [REST] Support for client certificates.
New: [Sage Intacct] Improved handling for object detail fields.
New: [Salesforce] Updated to use latest 54 API version.

Library 2.1.2.2621 Published: Tuesday, January 25, 2022 - 07:13

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Deprecated: [OneDrive] Use 'Microsoft Graph' configuration instead.
Fixed: [ArcGIS Feature] Corrected based endpoint template to follow ESRI documentation example.
Fixed: [Base] Error Disposition page in various components editors didn't save edits unless the user moved to another page before closing the editor.
Fixed: [Base] If there is an exception during the list loading, the VS crashes.
Fixed: [Base] Mappings page preserve sorting of columns after refresh.
Fixed: [Blackbaud] Pagination definitions for the School endpoints are now in the base template.
Fixed: [Bloomerang] The pagination had to be corrected to stop if the amount of records retrieved is less than the specified batch size.
Fixed: [Data Flow Task Plus] Define empty mapping for configured destination columns.
Fixed: [Data Flow Task Plus] Depending on how project/solution is loaded in Visual Studio, the editor was not displayed on double-click.
Fixed: [Data Flow Task Plus] Detect when multiple source columns are mapped into the same destination column.
Fixed: [Data Flow Task Plus] Failure to process with not mapped column definition and specified mandatory list.
Fixed: [Data Flow Task Plus] Fixed issue related to Flat File Connection and downstream failures after first iteration.
Fixed: [Data Flow Task Plus] Implemented to report what modules fail to dynamically load.
Fixed: [Data Flow Task Plus] Issue with executing against SQL Server 2012.
Fixed: [Data Flow Task Plus] Issue with using ColumnAdded event handler when DelayValidation is False.
Fixed: [Data Flow Task Plus] Modified to configure script object model only if there is a script.
Fixed: [DataFlow Source] Issue when using in dynamic data flows.
Fixed: [Database Destination] Add handling for bulk processing for not officially supported databases.
Fixed: [Database Destination] Crash when loading list of tables for a given schema using the latest MySQL ODBC driver.
Fixed: [Database Destination] Error message missing when DB2 ADO.NET driver is used and the component is set to fail.
Fixed: [Database Destination] Error when SQL Server destination table uses user-defined type, as aliases.
Fixed: [Database Destination] In OLE DB bulk mode error rows were always redirected, regardless the setting.
Fixed: [Database Destination] In SQL Server the TempSchema property was ignored (tempdb was always used).
Fixed: [Database Destination] Issue with default value for BIT data type in ODBC.
Fixed: [Database Destination] Issues with handling NULL values in regular (non-bulk) mode.
Fixed: [Database Destination] Recognize IBM DB2 OLE DB driver.
Fixed: [Database Destination] Redirect rows violating integrity constraint when ODBC connection in bulk mode is used.
Fixed: [EDI Connection] Crash upon changing metadata in the EDI configuration file.
Fixed: [EDI Connection] Crash when Windows FIPS-only security setting is enabled.
Fixed: [EDI Destination] Issue with truncateable segments.
Fixed: [EDI Destination] Remove redundant subcomponent separator.
Fixed: [EDI Source] Escape symbol was not handled properly when multiple delimiter symbols were in use.
Fixed: [Eventbrite] Modified to use different Eventbrite app registration.
Fixed: [File Transfer Task] Remove redundant trailing slashes in folder names when browsing for an item.
Fixed: [File Transfer Task] Upload with specified full remote file path failed.
Fixed: [GoToWebinar] Issue with pagination.
Fixed: [Google BigQuery] Failed to read from Tabledata resource.
Fixed: [Google BigQuery] Included definition for NUMERIC field type.
Fixed: [Google Drive] Crash due to folders with thousands of items.
Fixed: [Google Drive] Item root folder was not configured properly in the GDrive.FileManager.getListing method.
Fixed: [Google Drive] Google.GDrive.getChildren function doesn't include the special @shared element.
Fixed: [Hubspot] Support for update of contact email.
Fixed: [Infusionsoft] Miscellaneous fixes.
Fixed: [JavaScript Component] Attempted conversion of the object to a primitive value failed.
Fixed: [JavaScript Component] Don't replace variables when reading code and parameter values.
Fixed: [Message Queue Task Plus] Fix validation when Action is ConfirmDelivery (queue is not needed).
Fixed: [Message Queue Task Plus] Got a "Body is not binary type" error when trying to read string message in AMQP compatible queue.
Fixed: [Message Queue Task Plus] Shouldn't require a value in a variable to pass validation.
Fixed: [Message Queue Task Plus] The General tab in the editor was empty.
Fixed: [Microsoft Dataverse] Implemented to generate new identifier for Upsert when no identifier is provided.
Fixed: [Microsoft Dataverse] In FetchXML processing take in account the specified attributes and the top element.
Fixed: [Microsoft Dataverse] Included code for handling of systemuser and team lookup fields.
Fixed: [Microsoft Dataverse] Included definition for proper create and update of lookup type fields.
Fixed: [Microsoft Dataverse] Modified to more reliably set the resource key field.
Fixed: [Microsoft Dataverse] Modified to enable for update child entities.
Fixed: [Microsoft Graph] Corrected Test URL for Service authentication.
Fixed: [Microsoft Graph] Fixed default Read endpoints.
Fixed: [Microsoft Graph] issue with setting of boolean values.
Fixed: [Mongo DB Connection] The "replicaSet" parameter is now optional.
Fixed: [NetSuite] Missing custom fields for 'VendorCredit' record.
Fixed: [ODBC Destination] Issue with incorrect handling of milliseconds in date values.
Fixed: [ODBC Destination] issue when inserting NULL values in numeric field with precision > 15 in PostgreSQL.
Fixed: [Package Connection] Visual issue when referencing a package (only in high-DPI).
Fixed: [Pipedrive] Custom field value was not retrieved properly.
Fixed: [PowerShell Task ] Disappearing "Script" tab contents after clicking "None".
Fixed: [Query] Use double quote (") for quoting names, because the square brackets are supported only by SQL Server.
Fixed: [REST Configuration Editor] The validation of the currently edited JS module didn't allow referencing code from other JS modules.
Fixed: [REST Connection] High-DPI issue with dialog for starting a new custom REST configuration.
Fixed: [REST Connection] Skip problematic empty path in Open API files.
Fixed: [REST Connection] Some HTTP requests were not retried in accordance with the Retry settings in the Advanced tab.
Fixed: [REST Connection] Some items might not be visible in OpenAPI import, due to missing scroller.
Fixed: [REST Connection] Location of the current element in Custom configuration editor not fully displayed when not fitting in a single line.
Fixed: [REST Destination] A crash in case Resource Manager parameters are not initialized.
Fixed: [REST Destination] Issue with configuring composite fields.
Fixed: [REST Destination] Small update to use the common extension method for NULL detection.
Fixed: [REST Source] A rare issue with processing fields in composite objects.
Fixed: [REST Source] Preview page may crash when displaying a huge number of columns.
Fixed: [REST Source] When editing parameters 'Delete' key was deleting the entire value instead of a single character.
Fixed: [REST Source] an issue when opening the detailed view for an individual row from the Preview page.
Fixed: [REST] Add proper "Content-type" depending on SOAP version when importing from WSDL.
Fixed: [REST] Better handling of JavaScript undefined values.
Fixed: [REST] Build proper resource's fields when importing from WSDL.
Fixed: [REST] Corrected element overwrite detection when processing Field.Item definitions.
Fixed: [REST] Cosmetic improvements in the wizards for importing OpenAPI and WSDL definitions.
Fixed: [REST] Crash when editing parameters without definition.
Fixed: [REST] Crash when there are no parameters configured for URL fields.
Fixed: [REST] Don't allow underscore in imported OpenAPI resource names, as it is a reserved symbol.
Fixed: [REST] Failed authentication when the connection was used in multiple parallel threads.
Fixed: [REST] Failed to cast values from array into string.
Fixed: [REST] Issue with handling minus (-) symbol, when converting from XML to JSON.
Fixed: [REST] Issue with processing JSON with numbers expressed in scientific notation, where the second part starts with a zero (e.g. -7E-05).
Fixed: [REST] Modified not to execute an action if input set is empty after excluding special fields.
Fixed: [REST] Modified to apply first explicit Read templates (higher priority).
Fixed: [REST] Modified to be possible to "short-circuit" the initialization of external resource fields from the configuration.
Fixed: [REST] Non-enumerable parameters are now properly ignored when preparing the web request.
Fixed: [REST] Preserve endpoints order when deselecting endpoints from the wizard in OpenAPI Import.
Fixed: [REST] Search for types in getClrType also in already loaded assemblies.
Fixed: [RabbitMQ Connection] RoutingKey visible in Send Message according to Exchange type.
Fixed: [RabbitMQ] Durable exchange error.
Fixed: [RabbitMQ] Message manual delivery problem.
Fixed: [Salesforce Destination] NullReferenceException error related to external columns with custom properties.
Fixed: [ServiceNow] Retrieve less fields to construct the resource's metadata.
Fixed: [Shopify] Implemented common object definitions for reuse in multiple resources.
Fixed: [Shopify] Updated to use latest API version.
Fixed: [Smartsheet] Implemented proper handling for text/number fields.
Fixed: [Table Difference] Clarify that "Update ID" applies only to "Compare" columns (i.e. not "Use New" and "Use Old").
Fixed: [Tableau] Incorrect pagination definition.
Fixed: [Tableau] issue with refresh token handling.
Fixed: [Teamwork] Pagination support.
Fixed: [UiPath] Disabled Read for Log resource.
Fixed: [Visual Studio Addon] In Visual Studio About box, a wrong version/build number of the extension was displayed
New: Support for custom Amazon S3 properties in File Transfer Task UI.
New: Support multi-root XML string formatting in REST Source/Destination parameters.
New: [Amazon Athena] New configuration.
New: [Amazon S3] Modified existing Amazon S3 Task/Connection to inform they are deprecated by a REST-based configuration
New: [Amazon S3] Support for session token.
New: [Azure Table] New configuration.
New: [Base] Enable drag&drop of variable placeholders in task & component editors.
New: [Base] In the mapping screen for destination components, indicate which columns differ in data type and other column properties.
New: [Blackbaud] Included more definitions update and delete in 'Church | Gift' resource.
New: [Blackbaud] Included support for new NXT endpoints.
New: [Database Destination] Support for custom WHERE clause for UPDATE, DELETE and UPSERT actions.
New: [Database Destination] Support for triggers firing.
New: [Dynamics Business Central] New configuration.
New: [Dynamics CRM Connection] Permit creation of connection manager without specifying "Organization" parameter" (workaround for the disabling of the discovery service for Dynamics 365).
New: [EDI Connection] Validation for problematic characters in xmlTag in EDI config files.
New: [EDI Destination] Add support for escaping delimiters.
New: [File Transfer Task] Add support for Salesforce Files.
New: [File Transfer Task] In the files/folder browser display also files when "Action" is "Receive files" or "Delete remote files".
New: [File Transfer Task] Support for recursive sending of subfolders.
New: [File Transfer Task] Support for retrying upon intermittent errors.
New: [Google BigQuery] Implemented support for nested (RECORD) fields.
New: [Google Maps] New configuration.
New: [Google People] New configuration.
New: [Installer] Abort the setup if SSIS/SSDT prerequisites are not installed.
New: [JavaScript] Expose additional properties and methods of Microsoft.SqlServer.Dts.Runtime.Variable to use in JavaScript scripting.
New: [JotForm] New configuration.
New: [Kintone] New configuration.
New: [License Manager] Target .NET Framework 4.0.
New: [LinkedIn] The client id and secret are now configurable during the token generation.
New: [Microsoft Dataverse] Add support for FetchXML in data retrieval.
New: [Microsoft Dataverse] Included support for 'continue-on-error' data processing.
New: [Microsoft Dataverse] Support for FetchXML -> link-entity element.
New: [Microsoft Graph] Enhanced configuration for various parameters.
New: [PDF Source] Introduced component for reading tabular data from PDF files.
New: [Pardot] Implemented support for OAuth authentication. Other improvements and enhancements.
New: [Parquet Destination] Add support for Apache Parquet files generation.
New: [Parquet Source] Support for reading Apache Parquet files.
New: [PayPal] New configuration.
New: [PowerShell Task] Expose additional properties and methods of Microsoft.SqlServer.Dts.Runtime.Variable to use in PSH scripting.
New: [QuickBooks Online] New configuration.
New: [REST] Allow setting a template field for a template field in REST Editor.
New: [REST] Custom editor for user parameters in XML format.
New: [REST] Deduce the JavaScript transformation expression necessary to parse a response from an example.
New: [REST] Enable storing REST API Tokens in SQL Server.
New: [REST] Import of WSDL definition for interacting with SOAP services
New: [REST] Support for enhanced UI controls populated with JavaScript.
New: [REST] Updated OpenApi.NET to v.1.2.3 .
New: [Salesforce Connection] Up-to-date Salesforce URLs (production and sandbox) in the Advanced tab.
New: [Salesforce Source] Elaborate & optimize usage of LIMIT statement in metadata initialization.
New: [Salesforce Source] Prevent errors in metadata initialization due to WHERE clause leading to no records returned for analysis.
New: [Salesforce] Introduce settings for automatic retries for handling intermittent errors.
New: [Stripe] New configuration.
New: [Typeform] New configuration.
New: [Zoho Sheet] New configuration.

Library 2.0.101.2620 Published: Tuesday, January 25, 2022 - 06:06

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Fixed: [Database Destination] Recognize IBM DB2 OLE DB driver.
Fixed: [File Transfer Task] When working with REST connections address issues with renaming files and with modifying the working directory when RetainSameConnection is true.
Fixed: [Hubspot] Support for the update of contact email.
Fixed: [Microsoft Common Data Service] Handle systemuser and team lookup fields.
Fixed: [ODBC Destination] Issue with incorrect handling of milliseconds in date values.
Fixed: [Pipedrive] Custom field value was not retrieved properly.
Fixed: [REST Configuration Editor] The validation of the currently edited JS module didn't allow referencing code from other JS modules.
Fixed: [REST Source] Preview page may crash when displaying a huge number of columns.
Fixed: [REST Source] an issue when opening the detailed view for an individual row from the Preview page.
Fixed: [REST] Corrected element overwrite detection when processing Field.Item definitions.
Fixed: [REST] Implemented not to crash when there are no parameters configured for URL fields.
Fixed: [REST] Improve detection of XML content in responses.
Fixed: [REST] Improve handling of a race condition with simultaneous attempts to use the refresh token.
Fixed: [REST] Issue with handling (-) minus symbol, when converting from XML to JSON.
Fixed: [REST] Modified not to execute an action if the input set is empty after excluding special fields.
Fixed: [REST] Modified to apply first explicit Read templates (higher priority).
Fixed: [REST] Modified to be possible to "short-circuit" the initialization of external resource fields from the configuration.
New: [Database Destination] Support for triggers firing.
New: [License Manager] Target .NET Framework 4.0 platform.

Library 2.0.101.2520 Published: Wednesday, December 1, 2021 - 06:32

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Fixed: [ArcGIS Feature] Corrected based endpoint template to follow ESRI documentation example.
Fixed: [Database Destination] Add handling for bulk processing for not officially supported databases.
Fixed: [Database Destination] Crash when loading list of tables for a given schema using the latest MySQL ODBC driver.
Fixed: [Database Destination] In OLE DB bulk mode error rows were always redirected, regardless the setting.
Fixed: [Database Destination] Issues with handling NULL values in regular (non-bulk) mode.
Fixed: [EDI Destination] Issue with truncateable segments.
Fixed: [EDI Source] Escape symbol was not handled properly when multiple delimiter symbols were in use.
Fixed: [General] Error Disposition page in various components editors didn't save edits unless the user moved to another page before closing the editor.
Fixed: [General] Restore sorting in mappings control surface grids after refresh.
Fixed: [GoToWebinar] The pagination never stops.
Fixed: [JavaScript Component] Attempted conversion of the object to a primitive value failed".
Fixed: [Microsoft Common Data Service] Fix for lookup fields without configured target.
Fixed: [NetSuite Source] Missing custom fields for 'VendorCredit' record.
Fixed: [REST Connection Manager] Failed authentication when connection was used in multiple threads.
Fixed: [REST Connection Manager] High-DPI issue with dialog for starting a new custom REST configuration.
Fixed: [REST Connection Manager] Location of current element in Custom configuration editor not fully displayed when not fitting in a single line.
Fixed: [REST Connection Manager] Non-enumerable parameters are now properly ignored when preparing the web request.
Fixed: [REST Connection Manager] Search for types in getClrType also in already loaded assemblies.
Fixed: [REST Connection Manager] Some items might not be visible in OpenAPI import, due to missing scroller.
Fixed: [REST Connection Manager] better handling of JavaScript undefined values.
Fixed: [Salesforce Connection Manager] Have up-to-date Salesforce URLs (production and sandbox) in the Advanced tab.
Fixed: [Tableau] Incorrect pagination definition.
Fixed: [Tableau] Issue with refresh token element definition.
Fixed: [Teamwork] Pagination support.
New: [Database Destination] Custom match clause.
New: [Database Destination] In telemetry track also OLE DB provider.
New: [General] In the mapping screen for destination components, indicate which columns differ in data type and other column properties.

Library 2.0.101.2435 Published: Monday, October 4, 2021 - 07:44

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Fixed: [Data Flow Task Plus] Failure to process with not mapped column definition and specified mandatory list.
Fixed: [Google BigQuery] Failed to read from Tabledata resource.
Fixed: [Google Drive] Item root folder was not configured properly.
Fixed: [Microsoft CDS] issues with lookup type fields.
Fixed: [ODBC Destination] issue when inserting NULL values in numeric field with precision > 15 in PostgreSQL
Fixed: [Query] Use double quote (") for quoting names, because the square brackets are supported only by SQL Server.
Fixed: [REST Destination] Issue with configuring composite fields.
Fixed: [REST Source] a rare issue with processing fields in composite objects
Fixed: [REST] Issue with processing JSON with numbers expressed in scientific notation, where the second part starts with a zero (e.g. -7E-05)
New: [Salesforce Source] Optimizations and fixes in metadata initialization

Library 2.0.101.2334 Published: Sunday, August 8, 2021 - 00:48

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Fixed: [Data Flow Task Plus] Depending on how project/solution is loaded in Visual Studio, the editor was not displayed on double-click
Fixed: [Database Destination] Error when SQL Server destination table uses user-defined type, as aliases
Fixed: [Database Destination] In SQL Server the TempSchema property was ignored (tempdb was always used)
Fixed: [File Transfer Task] Backwards compatibility issue (introduced in build 2249) remote folder name when sending a single file
Fixed: [Google Sheets] Issue with file cache
Fixed: [Package Connection] Visual issue when referencing a package (only in high-DPI)
Fixed: [REST Connection] Some HTTP requests were not retried in accordance with the Retry settings in the Advanced tab
New: [EDI Destination] Add support for escaping delimiters
New: [Installer] Abort the setup if SSIS/SSDT prerequisites are not installed
New: [JavaScript] Expose additional properties and methods of Microsoft.SqlServer.Dts.Runtime.Variable to use in JS scripting
New: [LinkedIn] The client id and secret are now configurable during the token generation

Library 1.9.102.2330 Published: Saturday, August 7, 2021 - 23:37

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Fixed: [REST Connection] Some HTTP requests were not retried in accordance with the Retry settings in the Advanced tab - 2569
Fixed: [Test] Use http protocol in RSS Source test (workaround failing test) - 2573
New: [JavaScript] Expose additional properties and methods of Microsoft.SqlServer.Dts.Runtime.Variable to use in JS scripting - 2560
Fixed: [Package Connection] Visual issue when referencing a package (only in high-DPI). - 2555
Fixed: [EDI Destination] Remove redundant subcomponent separator. - 2517
New: [EDI Connection] Add support for file encoding - 2538
Fixed: [ServiceNow] Retrieve less fields to construct the resources metadata. - 2525
Fixed: [Mongo DB Connection] The "replicaSet" parameter is now optional - 2520
Fixed: [EDI Connection] Crash when Windows FIPS-only security setting is enabled - 2513
Fixed: [Google BigQuery] Included definition for NUMERIC field type. - 2506
Fixed: [Microsoft Common Data Service] A regression issue. - 2503
Fixed: [DataFlow Source] Issue when using in dynamic data flows - 2479
Fixed: [Data Flow Task Plus] Fixed issue related to Flat File Connection and downstream failures after first iterations - 2473
Fixed: [Dynamics CRM] Online tests - 2477
Fixed: [Microsoft Common Data Service] Modified to more reliably set the resource key field - 2455

Library 2.0.100.2249 Published: Thursday, July 22, 2021 - 03:16

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

NOTE: The build has introduced a regression in File Transfer Task, when sending a single file or a stream. The issue will be fixed in the upcoming build.

Fixed: [Blackbaud] Pagination definitions for the School endpoints are now in the base template.
Fixed: [Data Flow Task Plus] Define empty mapping for configured destination columns.
Fixed: [Data Flow Task Plus] Detect when multiple source columns are mapped into the same destination column.
Fixed: [Data Flow Task Plus] Fixed issue related to Flat File Connection and downstream failures after first iterations
Fixed: [Data Flow Task Plus] Issue with executing against SQL Server 2012
Fixed: [DataFlow Source] Issue when using in dynamic data flows
Fixed: [Database Destination] Error message missing when DB2 ADO.NET driver is used and the component is set to fail.
Fixed: [Database Destination] Issue with default value for BIT data type in ODBC
Fixed: [EDI Connection] Crash upon changing metadata in the EDI configuration file
Fixed: [EDI Connection] Crash when Windows FIPS-only security setting is enabled
Fixed: [EDI Destination] Remove redundant subcomponent separator.
Fixed: [File Transfer Task] Enable specifying different local file name when uploading a file.
Fixed: [File Transfer Task] Upload with specified full remote file path failed.
Fixed: [Google BigQuery] Included definition for NUMERIC field type.
Fixed: [Microsoft CDS] A regression issue.
Fixed: [Microsoft Dataverse] Modified to more reliably set the resource key field
Fixed: [Mongo DB Connection] The "replicaSet" parameter is now optional
Fixed: [REST Connection] Skip problematic empty path in Open API files
Fixed: [Salesforce Destination] NullReferenceException error related to external columns with custom properties
Fixed: [ServiceNow] Retrieve less fields to construct the resources metadata.
Fixed: [UiPath] Disabled Read for Log resource.
New: [Blackbaud] Included support for new NXT endpoints.
New: [Dynamics CRM] All creating connection manager without specifying "Organization" parameter" (workaround for the disabling of the discovery service for Dynamics 365).
New: [EDI Connection] Validation for problematic characters in xmlTag in EDI config files
New: [Google BigQuery] Implemented support for nested (RECORD) fields.

Library 2.0.100.2142 Published: Monday, May 17, 2021 - 09:20

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.1.1.2141 Published: Monday, May 17, 2021 - 07:56

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 1.9.102.2138 Published: Saturday, May 15, 2021 - 03:04

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 2.0.100.2082 Published: Monday, April 12, 2021 - 10:44

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.100.2053 Published: Monday, March 22, 2021 - 04:22

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.100.1985 Published: Thursday, February 25, 2021 - 12:30

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.100.1961 Published: Tuesday, February 16, 2021 - 07:51

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.100.1956 Published: Thursday, February 11, 2021 - 09:11

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 1.9.101.1909 Published: Wednesday, January 20, 2021 - 06:04

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 2.0.100.1903 Published: Friday, January 15, 2021 - 11:26

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.100.1868 Published: Monday, December 14, 2020 - 06:59

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.100.1844 Published: Saturday, December 5, 2020 - 03:30

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.100.1810 Published: Tuesday, November 24, 2020 - 12:50

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.100.1735 Published: Tuesday, October 6, 2020 - 02:26

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.100.1689 Published: Saturday, September 5, 2020 - 06:41

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.2.1667 Published: Tuesday, August 25, 2020 - 15:32

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 1.9.101.1658 Published: Saturday, August 22, 2020 - 14:51

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 2.0.2.1647 Published: Thursday, August 13, 2020 - 10:33

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.2.1638 Published: Saturday, August 8, 2020 - 09:06

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.2.1611 Published: Monday, July 27, 2020 - 08:03

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 1.9.100.1609 Published: Monday, July 27, 2020 - 05:08

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 2.0.2.1586 Published: Tuesday, June 30, 2020 - 13:09

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 1.9.100.1552 Published: Thursday, June 11, 2020 - 11:12

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 2.0.2.1549 Published: Wednesday, June 10, 2020 - 12:31

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 1.9.100.1528 Published: Wednesday, May 27, 2020 - 03:10

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 2.0.1.1505 Published: Tuesday, May 12, 2020 - 07:18

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 2.0.1.1480 Published: Monday, April 27, 2020 - 15:13

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 1.9.100.1478 Published: Monday, April 27, 2020 - 08:26

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 1.9.100.1406 Published: Tuesday, March 17, 2020 - 16:14

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Fixed: UI layout issues in component editors under the latest SSIS Projects Addon for Visual Studio 2019

Library 2.0.1.1354 Published: Wednesday, February 19, 2020 - 08:09

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Fixed UI layout issues in component editors under the latest SSDT in Visual Studio 2019

Library 1.9.100.1314 Published: Monday, February 3, 2020 - 04:18

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Fixed: Script Component Plus dialog crash when using Visual Studio 2019, resulting in error message "Object reference not set to an instance of an object"

Library 2.0.1.1313 Published: Sunday, February 2, 2020 - 12:13

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 1.9.100.1290 Published: Sunday, January 19, 2020 - 03:47

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 1.9.100.1275 Published: Wednesday, January 8, 2020 - 11:42

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 1.9.100.1227 Published: Saturday, December 7, 2019 - 01:21

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 2.0.1.1226 Published: Friday, December 6, 2019 - 22:50

64-bit (x64) SQL Server 2012-2019

32-bit (x86) SQL Server 2012-2019

Library 1.9.100.1191 Published: Thursday, November 21, 2019 - 17:44

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 1.9.100.1179 Published: Thursday, November 14, 2019 - 06:19

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 1.9.100.1161 Published: Thursday, October 31, 2019 - 05:34

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 1.9.100.1142 Published: Monday, October 14, 2019 - 04:31

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 1.9.100.1121 Published: Thursday, September 19, 2019 - 10:31

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 1.9.100.1101 Published: Wednesday, September 4, 2019 - 05:56

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Fixed: The "Enumerable" settings of user parameters of REST Configurations were handled only in GET requests.

Library 1.9.100.1072 Published: Thursday, August 1, 2019 - 12:49

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Library 1.9.100.1049 Published: Thursday, July 4, 2019 - 08:14

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Bug fixes

Library 1.9.100.1041 Published: Monday, July 1, 2019 - 08:45

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

First official 1.9 build

Library 1.9.1.1024 Published: Tuesday, June 18, 2019 - 08:00

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

New: Act-On REST configuration.
New: Telemetry functionality.

Library 1.9.1.1011 Published: Friday, June 7, 2019 - 08:19

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

New: Sailthru REST configuration.
New: Support for Visual Studio 2019.

Library 1.9.1.971 Published: Thursday, May 16, 2019 - 13:19

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

New: Complete support for user-defined embedded RCM configurations in REST Connection Manager

Library 1.9.1.952 Published: Wednesday, May 8, 2019 - 17:23

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

New: Microsoft Common Data service REST configuration.

Library 1.9.1.909 Published: Thursday, April 11, 2019 - 05:01

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

New: KRONOS Connection
New: Improved support of COM objects in JavaScript.

Library 1.9.1.888 Published: Monday, April 1, 2019 - 07:21

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

New: Support for user-defined embedded RCM configurations in REST Connection Manager (Resources not yet supported)
New: Sisense service REST configuration.
Fixed: Problematic default values for components with no error output in dynamic data flows (Data Flow Task Plus).
Fixed: Some High DPI scaling issues.

Library 1.9.1.808 Published: Friday, February 22, 2019 - 04:23

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

New: WordPress service REST configuration.
New: Finalized support for High DPI scaling.
New: Improvements in JavaScript scripting.

Library 1.9.1.766 Published: Wednesday, February 6, 2019 - 08:42

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Fixed: Regression issue with processing data from REST Adapters.

Library 1.9.1.761 Published: Friday, February 1, 2019 - 16:03

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

New: PureCloud service REST configuration.
New: Support for Office 365 token-based authentication in Exchange connection.
New: Display a busy indicator when initializing forms that take a lot of time to load.
Fixed: Race conditions in REST execution engine
Fixed: Typos in methods names in component.metadata.js (several JavaScript Component scripts are updated, too)

Library 1.9.1.679 Published: Friday, December 21, 2018 - 17:37

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

Fixed: Salesforce Source metadata columns names issue when missing a related object in the sample results.
New: Improvements in connection manager dialogs when running in High DPI mode.

Library 1.9.1.647 Published: Monday, December 10, 2018 - 07:36

64-bit (x64) SQL Server 2005-2019

32-bit (x86) SQL Server 2005-2019

New: Support for Zoho CRM v2 API.
New: JavaScript Component display of "Mappings" tab is controlled in the script
New: JavaScript Component now shows a readonly metadata report ("Input columns" and "Inputs and Outputs" are retired)
New: Support for afterEdit for JavaScript parameters
New: Helper methods for JavaScript Component in component.metadata.js
New: More declarative JavaScript validation via built-in functions like validation.required (breaking change)
New: Getting Help in the REST Connection Manager Editor now opens a more relevant documentation page (depending on the selected configuration and current tab)
New: Improve the metadata initialization in Salesforce Source when using SOQL statements (no more missing columns if result contains empty fields)
Fixed: The "Preview" of Salesforce Source data failed with "EXCEEDED_ID_LIMIT" error under some conditions.
Fixed: JavaScript Component affected Data Viewers in the Data Flow
Fixed: F1 was not working properly in some editor forms