SSIS is not installed by default when you install SQL Server 2005, but must be selected. ... SSIS Service SSIS includes the SQL Server Integration Services service, a Windows service that is used to manage ... When running, the Integration Services service allows you to do the following from Management Studio: Start and stop remote ... However, it must be active in order to list and monitor packages using Management Studio, as well as monitor packages stored in the package store.
|Title||:||Mastering Microsoft SQL Server 2005|
|Author||:||Mike Gunderloy, Joseph L. Jorden, David W. Tschanz|
|Publisher||:||John Wiley & Sons - 2006-03-06|