- 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 whenDelayValidation
isFalse
. - 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.
- Bug fixes
- First official 1.9 build
- 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: EDI Connection
- New: EDI Destination
- New: JavaScript Task.
- New: JavaScript Component.
- New: Support for SQL Server 2019
- New: Support for NetSuite token-based authentication.