My package contains 2 data flow tasks, I want to have 2 log providers, one log for error events second log for information,warning events.. but while configuring like that ,i got messed up.. so how can i achieve this . What i did is Added 2 log providers.. selected 1 log provider and and selected On error event selected 2ed log provider and went to detail section , it is showing previous selection can't we do my requirement by using SSIS.. Thanks , RAVIKIRAN.M

Hi Ravi, Yes, you can configure multiple log providers. Thanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com

you can split logging for every container with selecting specific containers in log providers window, but It seems that you can not split them by events.http://www.rad.pasfu.com

1) Why do you want to configure 2 log providers separeted for Onerror and other for Onwarning and Oninformation? 2) As per my testing this looks like not possible, some one can correct me. 3) The only way is to configure one log file connectoin and use it for all the events.Happy to help! Thanks. Regards and good Wishes, Deepak.

An option is to use the built-in log provider to log the warnings and informational messages, and to log the errors yourself with event handlers.MCTS, MCITP - Please mark posts as answered where appropriate.

So it seems, we can't do my requirement using SSIS . can any one explain, what is the use of having multiple log providers for the same package.. I got confused, please guide me in correct way. Thanks RAVI

So it seems, we can't do my requirement using SSIS . can any one explain, what is the use of having multiple log providers for the same package.. I got confused, please guide me in correct way. Thanks RAVI one of benefits for having multiple log providers is that you can split log providers by CONTAINER. for example all logs of foreach loop container in one log provider and all logs for script task in another log provider.http://www.rad.pasfu.com

So it seems, we can't do my requirement using SSIS . can any one explain, what is the use of having multiple log providers for the same package.. I got confused, please guide me in correct way. Your requirement can easily be met if you use event handlers.MCTS, MCITP - Please mark posts as answered where appropriate.

can you elaborate the the concept, Thank you..

can you elaborate the the concept, Thank you.. You can use the OnError event handlers to do custom logging. Check out the following links: http://msdn.microsoft.com/en-us/library/ms140223.aspx http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspxMCTS, MCITP - Please mark posts as answered where appropriate.