• 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
  • 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
  • Fixed: UI layout issues in component editors under the latest SSIS Projects Addon for Visual Studio 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"

  • Fixed: The "Enumerable" settings of user parameters of REST Configurations were handled only in GET requests.
  • New: Act-On REST configuration.
  • New: Telemetry functionality.
  • New: Sailthru REST configuration.
  • New: Support for Visual Studio 2019.
  • New: Complete support for user-defined embedded RCM configurations in REST Connection Manager
  • New: Microsoft Common Data service REST configuration.
  • New: KRONOS Connection
  • New: Improved support of COM objects in JavaScript.
  • 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.
  • New: WordPress service REST configuration.
  • New: Finalized support for High DPI scaling.
  • New: Improvements in JavaScript scripting.
  • Fixed: Regression issue with processing data from REST Adapters.
  • 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)
  • 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.
  • 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
  • New: JavaScript Task.
  • New: JavaScript Component.
  • New: Support for NetSuite token-based authentication.