SQL Server 2016 improvements
SQL Server 2016 introduced the SQL Server Integration Services Database Package (SSISDB) Upgrade Wizard. This tool enables IT pros to upgrade the catalog database when it is older than the current version of SQL Server. It can also be used in some disaster recovery situations that require a restoration from backup. The SSISDB Wizard upgrades the catalog database to match whatever version of SQL Server is being used.
SQL Server 2016 Integration Services enables admins to add an SSIS catalog database to an AlwaysOn Availability Group. It also includes improved package management, where admins can save a container or a control flow task as a reusable template through Integration Services. Also included within SQL Server 2016 was an SSIS Feature Pack for Azure. This allows admins to connect to Azure data sources and to transfer data between the Azure cloud and data sources that are located on premises.
Microsoft released connectors for SSIS in 2016, including the Connector for SAP Business Warehouse for SQL Server 2016, Connector versions 4.0 for Oracle and Teradata, and the Connector for Analytics Platform System Appliance Update 5.
SQL Server 2017 improvements
SQL Server 2017 brought new SSIS features, such as Scale Out for SSIS, which makes it easier to run SSIS on multiple machines. Admins can avoid a single point of failure for the entire Scale Out deployment. Also included is an improvement to the failover handling of the executing logs from Scale Out Workers. The execution logs persist to local disk if the Scale Out Worker stops suddenly.
The SSIS catalog also includes a new global property which specifies the default mode to execute SSIS packages. This applies when IT pros call the stored procedure with the runinscaleout parameter set to null.
PLS CONTACTFOR MORE DETAILS CALL IMMEDIATE: 9360029290 / 9442173717
Fu-VISION TRAINING SOLUTION PVT LTD
COIMBATORE: HEAD OFFICE
NO: 96-A SREE NAGAR,
PALANI AANDAVAR ILLAM, 1nd FLOOR OPP KRISHNA SWEETS,
AVINASHI ROAD, PEELAMEDU,
HOPES COLLEGE BUS STOP,
SAI TOWERS, DIAGONALLY OPP TO GANGA-YAMUNA-KAVERI THEATRE
ABOVE BAJAJ MOTORCYCLES,
GP (100FT ROAD) COIMBATORE-641012
MAIL ID: firstname.lastname@example.org
Mobile number: 9360029290