Managing Integration Services

Microsoft SQL Server Integration Services includes the Integration Services service, a Windows service for managing Integration Services packages. The Integration Services service is available only in SQL Server Management Studio.

Running the Integration Services service provides the following management capabilities:

• Starting remote and locally stored packages

• Stopping remote and locally running packages

• Monitoring remote and locally running packages

• Importing and exporting packages

• Managing package storage

• Customizing storage folders

• Stopping running packages when the service is stopped

• Viewing the Windows Event log

• Connecting to multiple Integration Services servers

The Integration Services service is installed when you install the Integration Services component of SQL Server. By default, the Integration Services service is started and the startup type of the service is set to automatic. The service must be running to monitor the packages that are stored in the SSIS Package Store. The SSIS Package Store can be either the msdb database in an instance of SQL Server or the designated folders in the file system.

The Integration Services service is not required if you only want to design and execute Integration Services packages. However, the service is required to list and monitor packages using SQL Server Management Studio.

In This Section

• Managing the Integration Services Service
  Describes how to start and stop the service itself and to view the events and logs that it generates.

• Configuring the Integration Services (SSIS) Service
  Describes how to configure options for the service, including folders for the storage of packages.

• Configuring a Windows Firewall for Integration Services Access
  Describes how to configure an instance of the service to allow access through a firewall.

• Connecting to a Remote Integration Services Server
  Describes how to configure an instance of the service to allow access from other computers.

Stay Up to Date with Integration Services For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.

See Also

Concepts

Managing Packages

Architecture of Integration Services

Administration (Integration Services)

SQL Server Integration Services