Expert SQL Server™ 2005 Integration Services

9.1. The Package Store

When you deploy your packages, they are stored into what is called the SSIS Package Store. The Package Store, in some cases, will actually physically store the package, as in the msdb database option. Or, in the case, of the file system, the Package Store just keeps a pointer to a specific top-level directory and enumerates through the packages stored underneath that directory. To connect to the Package Store, the SSIS Service must be running. This service is called SQL Server Integration Services, or MsDtsServer. There is only one instance of the service per machine, or per set of clustered machines.

You can configure the SSIS service in the Services applet in Control Panel Administrative Tools. Double-click on the SQL Server Integration Services item. As you can see, the service is set to automatically start by default and starts under the NT AUTHORITY\NetworkService account. In the Recovery tab, you may decide that you want the service to automatically restart in the event of a failure—you can specify how to react if the service fails the first, second, and subsequent times. As you can see in Figure 9-1, the service has been changed to restart if a failure occurs twice. The failure count in this figure is also reset after two days.

Figure 9-1. Configuring the service to restart in the event of a failure

Although you can run and stop packages without ...