Professional Microsoft® SQL Server® 2008 Administration

Chapter 6. Integration Services Administration and Performance Tuning

In keeping with the theme of focusing on how SQL Server 2008 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 2008 Business Intelligence stack includes Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS). We focus on Integration Services and Analysis Services in this book, because these components require considerable understanding in order to manage successfully.

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 can be more comfortable with and have a better understanding of the moveable parts that require the attention of an administrator. After getting 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'll 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'll learn how to secure all of the Integration Services components.

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