Microsoft SQL Server Component Release Notes

DI-8197: Third-party library upgrade.

DI-7793: JDBC Driver Third-party library upgrade.

DI-7305: SQL Server datatypes with maximum size such as varchar(max) should be reverse engineered as returned by the JDBC Driver, and the max keyword specified only at datatype creation.

DI-7317: New uselessUpdateDetectionMethod parameter in the Integration MSSQL template to optimize performances by comparing incoming data with target data.

DI-9076: Added support for XML field types in database metadata and integration flows.

DI-8015: Random error bad file does not exist with the LOAD Rdbms to Mssql template when using the Bulk Load Method.

DI-4589: The Create Load Indexes option has been added to the LOAD File to Mssql template.

DI-4590: The Create Load Indexes option has been added to the LOAD Rdbms to Mssql template.

DI-4671: The Create indexes on Target Table parameter has been added to the INTEGRATION File to Mssql template.

DI-5184: The collation property has been added to columns. It can be reverse-engineered used in the

DI-5372: The geometry datatype is now supported.

DI-5463: Error file management has been implemented for both the BULK and BCP actions in all the templates.

DI-5970: MSSQL - Third-party library upgrade.

DI-6243: The DEFAULT constraint management is disabled on timestamp and identity datatypes.

DI-4616: In the STAGING Mssql As Table template, a tooltip is missing on the Create Stage Indexes parameter.

DI-5630: The third-party libraries are missing in the Microsoft SQL Server third-party packs.

DI-5830: The templates that use the bcp command do not work when there is a backslash character (\) in the file path.

DI-2117: Microsoft SQL Server Component - update module definition to propose more accurate driver and urls

DI-1776: LOAD File to Mssql - new option 'SuccessIfNoFile' to create an empty table, if the source file does not exist

DI-1794: Support reversing indexes

DI-1912: Templates updated - support having CDC sources on Templates which were not supporting it (such as staging templates)

DI-1910: Templates updated - New parameter 'Cdc Subscriber' on Templates on which it was not handled yet

DI-1909: Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking

DI-1818: Syntax to drop an index was not correct

DI-1907: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates when querying the source data

DI-2695: Template - LOAD File to MSSQL - improve the execution of BCP command and the logged command to be clearer

DI-2744: Template - LOAD Rdbms to Mssql - generated temporary file names may unexpectedly contain object delimiters

DI-2868: Template - Load Rdbms to Mssql - new parameter named "Code Page" which allows to define the code page used for BCP and BULK INSERT

DI-4160: Template - LOAD Rdbms to MSSQL - improve the execution of BCP command and the logged command to be clearer

DI-4530: Template - Integration Mssql - recreate indexes on target table when it is dropped and recreated by the Template

DI-4537: Template - Staging Mssql As Table - new parameter "Create Stage Indexes"

DI-4562: Template - Integration MSSQL - new parameter "Create Indexes On Target Table"

DI-3625: Template - STAGING Mssql As View - the view is unexpectedly created without defining the catalog name, which leads the view to be created in the default catalog of the connection, which can be wrong

DI-4721: Microsoft SQL Server - SQL syntax generated to drop primary key is incorrect in some Templates

DI-2641: Reverse-engineer foreign keys referencing tables in another schema when the other table and schema are available in the metadata

DI-4508: Update Components and Designer to take into account dedicated license permissions

DI-4727: Rebranding: Templates and sample projects

DI-4731: Rebranding: Template messages

DI-4962: Improved component dependencies and requirements management

DI-5630 : The Microsoft SQL Server third-party packs are missing the third-party libraries.