May 2007
Intermediate to advanced
432 pages
11h 43m
English
Content preview from Expert SQL Server™ 2005 Integration Services
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.