I have five SSIS packages and they have been configured something like as below Parent package executes child1 Child1 executes child2 Child2 executes child3 Child3 executes child4 My assumption was if I configure logging for the Parent package then it will be applied to all child packages. However that is not true, of-course I can configure logging explicitly for each package but I would like to understand if there is any option to achieve my assumption.

Hi, Can you elaborate on "My assumption was if I configure logging for the Parent package then it will be applied to all child packages. However that is not true". What exactly have you configured, what are you expecting to happen, and what is is actually happening? Help us to help you. @Jamiethttp://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Well, If you doing logging with the help of DTEXEC command than it will not log child until there is any error in child. but if you have used logging in ETL packge it self than it should work, please check what events are you taking on advance , you might be just taking On error. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Hi Jamie, I have configured the Logging for the parent package as below. SSIS Tab---Selected logging---Selected Textfile log provider and assigned the textfile connectionvalue-----selected All events in details tab. in all the child packages set the LoggingMode=Use Parent settings. Package properties----LoggingMode=Use Parent settings.

Hi Gaurav, I have selected the all the events in details tab, However i dont see any Log events in logfile. Yes it is logging if the Child3 fails but i am concerned about OnvariableValuechaged event in the child packge.