Summary

We have discovered many of the various administrative functions related to Integration Services. After getting a general introduction to Integration Services, we reviewed important Integration Services administration tasks such as managing the Integration Services service, including configuration, event logs, and monitoring activity. Next, we provided some insights into various administrative tasks required of Integration Services packages, including creation, management, execution, and deployment. Last, we reviewed how to implement security for all of the various Integration Services components. In Chapter 7 we discuss similar administrative functions related to Analysis Services.