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: [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: [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: [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.
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: [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: [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: [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: [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: [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
Pages