Professional SQL Server™ 2005 Administration

Chapter 6. Integration Services Administration and Performance Tuning

In keeping with the theme of focusing on how SQL Server 2005 changes the role of the DBA, we now look at how you can be better equipped as a DBA to maintain the SQL Server's Business Intelligence components. The SQL Server 2005 Business Intelligence stack includes Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS). We focus our attention on Integration Services and Analysis Services in this book, because these components require considerable understanding in order to manage successfully. In this chapter, we look at the many and varied administrative tasks required for managing Integration Services. First, an overview of Integration Services 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, we focus on the administration of the Integration Services service 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, we review how to secure all of the Integration Services components.

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