I am executing the SSIS package and generating the execution log information in SQL server and text file. i.e. using the SSIS---->logging and there SSIS log provider for SQL server and SSIS log provider for text file. Now I want to push the execution information of all the events in SQL server whereas in text file I want to log only the OnError events. Now I am unable to to select the different set of the events for two log provider (SQL server and text file) Please suggest how to do this.

I think its a bug in SSIS Log Provider. What you will have to do is implement ssis logging using eventhandler Log Provider always logs Package Start and End For some reason. See this Article very well documented. http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx SSIS-Tutorials-FAQs | Convert DTS to SSIS | Document SSIS | SSIS Tasks | Real-time SSIS Monitoring