O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Installing SQL Server 2016

This section will go through the installation of SQL Server engine, which will host the database objects used throughout this book.

These are the features available for SQL Server setup:

  • Database engine: It is the core of SQL Server. It manages the various database objects such as tables, views, stored procedures, and so on.
  • Analysis services: It allows us to create a data semantic layer that eases data consumption by users.
  • Reporting services (native): It allow us to create various reports, paginated, mobile, and KPI's for data consumption.
  • Integration services: It is the purpose of this book, SQL Server data movement service.
  • Management tools: We'll talk about these in the next section.
  • SQL Server Data Tools ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required