O'Reilly logo

Professional Microsoft SQL Server 2012 Administration by Ross LoForte, Steven Wort, Adam Jorgensen, Brian Knight

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

Chapter 20

Integration Services Administration and Performance Tuning

WHAT’S IN THIS CHAPTER

  • Overview of SSIS
  • Deploy and Configure SSIS Packages
  • Secure and Administer SSIS
  • Common Pitfalls with SSIS Performance

In keeping with the theme of focusing on how SQL Server 2012 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 components. The SQL Server 2012 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.

image

For more in-depth information about Integration Services, see Professional ...

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