fixed

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

fixed

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

added

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

added

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

added

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

added

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

added

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

added

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

fixed

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

added

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

added

Support reversing indexes

added

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

added

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

added

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

fixed

Syntax to drop an index was not correct

fixed

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

added

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