Chapter 20Integration Services Administration and Performance Tuning


  • Getting to know SSIS
  • Deploying and configuring SSIS Packages
  • Securing and administering SSIS
  • Understanding common pitfalls with SSIS performance

In keeping with the theme of focusing on how SQL Server 2014 changes the role of the DBA, in this chapter you learn how you can be better equipped as a DBA to maintain SQL Server's Business Intelligence (BI) components. The SQL Server 2014 Business Intelligence stack includes Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).

This chapter looks at the many and varied administrative tasks required for managing Integration Services. First, an overview of the Integration Services service is provided so that you will have a better understanding of the moveable parts that require the attention of an administrator. After becoming comfortable with the architecture of Integration Services, you can focus on the administration of Integration Services, including configuration, event logs, and monitoring activity. Next, you gain an understanding of the various administrative tasks required of Integration Services packages, the functional component within SSIS, including creation, management, execution, and deployment. Last, you learn how to secure all the Integration Services components.


Get Professional Microsoft SQL Server 2014 Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.