Noob question: I've been using SSIS for several years, but haven't taken full advantage of it. I'm still a little confused about when you actually need to have the SSIS service installed, other than to allow the packages to be stored in the msdb database. My question is: Does the SSIS service need to be installed to allow SSIS logging to take place?Clint

My question is: Does the SSIS service need to be installed to allow SSIS logging to take place? I don't think that SSIS Service should be running for SSIS logging to take place. As is from http://support.microsoft.com/kb/942176 If you only want to design and to execute SSIS packages, you do not have to start the SSIS service. When the SSIS service is stopped, you can run SSIS packages by using the following utilities: The SQL Server Import and Export Wizard The SSIS designer The Execute Package utility (DTExecUI.exe) The DTExec.exe command prompt utility If you want to list and to monitor SSIS packages in SQL Server Management Studio, you must start the SSIS service. The SSIS service provides the following management capabilities in SQL Server Management Studio: Retrieve an SSIS package from remote storage or from local storage. Then, the SSIS service can locally execute the SSIS package without using SQL Server Agent jobs. Stop the SSIS packages that are running locally or remotely without using SQL Server Agent jobs. Monitor the SSIS packages that are running locally or remotely without using SQL Server Agent jobs. Import and export SSIS packages. Nitesh Rai- Please mark the post as answered if it answers your question

thank youClint