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.



at

1 comment:

Subscribe to: Post Comments (Atom)

T-SQL LEAD LAG and SUM function based query

  Query on T-SQL window clause Below is the sales table Order_Date Name Product SubCategory ...

  • Top 10 SSIS interview questions
    SSIS Interview Questions 1) What happens if we enable checkpoint and transaction together in SSIS package? Ans: Transaction alway...
  • DataZen Syllabus
    INTRODUCTION TO DATAZEN PRODUCT ELEMENTS ARCHITECTURE DATAZEN ENTERPRISE SERVER INTRODUCTION SERVER ARCHITECTURE INSTALLATION SEC...
  • PowerBI Interview Questions and Answers
    Power BI Interview Questions – General Questions 1). What is self-service business intelligence? Ans: Self-Service Business Intelligenc...