Microsoft SQL Server Component Release Notes

This page lists the main features added to the Microsoft SQL Server Component.

Change Log

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

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

INTEGRATION MSSQL template to create work tables with proper collation.

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.