Professional Microsoft® SQL Server® 2008 Administration

6.2. Administration of the Integration Services Service

Now that you have a better understanding of the parts of Integration Services, this section looks at the various administrative aspects of Integration Services, including the details needed to become comfortable working with the components. You'll start with a review of the Integration Services service and then look at various configuration elements of the service. Next, you'll look at how you can adjust properties of the SSIS service using either the Windows Services Snap-in or the SQL Server Configuration Manager. Understanding how you can modify Windows Firewall follows, and then you'll look at the management and configuration of event logs, and performance monitoring.

6.2.1. An Overview of the Integration Services Service

The Integration Services service is a Windows service used to manage SSIS packages. Accessed through SQL Server Management Studio, it provides the following management capabilities:

• Starting and stopping local and remote packages.

• Monitoring local and remote packages.

• Importing and exporting packages from different sources.

• Managing the package store.

• Customizing storage folders.

• Stopping running packages when service is stopped.

• Viewing the Windows Event Log.

• Connecting to multiple SSIS server instances.

To be very clear, you don't need this service for designing or executing packages. The primary purpose of this service is to manage packages within Management Studio. One side benefit to having the service ...