Microsoft SQL Server Component Release Notes

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

Change Log

Version 2023.3.0

Feature improvements

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

Bug fixes

  • 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.

Version 2023.2.0

Feature improvements

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

Version 2023.1.10

Feature improvements

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

Version 2023.1.4 (Microsoft SQL Server Component)

Bug fixes

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

Version 2023.1.0 (Microsoft SQL Server Component)

Feature improvements

  • 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.

Bug fixes

  • 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.

Version 2.0.1 (Microsoft SQL Server Component)

Feature improvements

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

Version 2.0.2 (Microsoft SQL Server Component)

Feature improvements

  • 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

Bug fixes

  • 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

Version 2.0.3 (Microsoft SQL Server Component)

Feature improvements

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

Bug fixes

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

Version 2.0.4 (Microsoft SQL Server Component)

Feature improvements

  • 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

Version 2.0.5 (Microsoft SQL Server Component)

Feature improvements

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

Version 2.0.6 (Microsoft SQL Server Component)

Feature improvements

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

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

Version 2.0.7 (Microsoft SQL Server Component)

Bug fixes

  • 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

Version 2.0.8 (Microsoft SQL Server Component)

Bug fixes

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

Version 3.0.0 (Component Pack)

Feature improvements

  • 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

Version 5.3.4 (Component Pack)

Bug fixes

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