Expert SQL Server™ 2005 Integration Services

9.2. Management Studio

In SSIS, there's delineation between development and administration. This makes the development model much more like developing a regular program. In a web application, you would never make a code change to the C# application on the production server. Instead, if you wanted to make a change, you would check it out of Source Control, make the change, and then redeploy. The same C# model applies to SSIS.

When you open Management Studio, select the Connect drop-down box in the Object Explorer window and select Integration Services. When you connect, you will see all the different stores that are available for you to explore.

A connection to that store isn't made until you expand one of the folders, as shown with the File System store in Figure 9-2. At that point, you may experience a timeout if you're trying to connect to an msdb database that isn't online, or when the server is offline. Otherwise, when you expand the folder, you will see a list of folders and packages that are stored in that particular store.

You can also access all the packages that are running under the Running Packages folder. From there, you can stop packages that are running too long by right-clicking the package and selecting Stop. You can also right-click the folder and select Reports General to see a report of all the packages running and for how long. This method of accessing the Reports ...