Sunday, December 3, 2017

SQL Server Integration services 2017

SQL Server Integration Services 2017 new features

  • scale out - this is the most waited feature for better buffer management and performance and high availability.
  • New SSIS supports SQL Server in Linux environment, it allows you to run SSIS in Linux environment using command line.
  •  Distributed processing of the SSIS could have been possible due to the scale out feature.
  • Odata source and connection manager supports Odata feed from Dynamics Ax and Dynamics CRM online.
  • Now you can deploy your SSIS package in Azure SQL SSIS Catalogue (SSISDB).
Many improvements done on database engine, MDS, Analysis Services and Azure Feature pack.



1 comment:

PowerBI monthly report refresh

How to setup monthly refresh for PowerBI ? PowerBI generally allows daily or weekly refreshes with options of selecting multiple time values...