How to log ssis within container level task Execution in sql server 2008
Dear team, we have created ssis package to Fetch teh data from oracle to sqlserver. we have a main package included child package.within the package having containers and tasks. we have enabled logging on main package and child package (only preexecute and post execute events).but i have captured only packge start ,preexeute,postexecute,end time of the package only. i am not able to pick the Tasks and containers(preexecute and post execute evets) within the packge .whenever i enable logging i have Selected all tasks,containers within the packge . anything else i need to do .pls eXplain me the way to capture of the all taks and containers selected events from the packages
October 26th, 2012 3:12am

and what happened ? did you got error? or logging doesn't worked? could you explain the exact problem ?http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2012 4:18pm

Hi KONDAPATURU, Logs are associated with packages and are configured at the package level. Each task or container in a package can log information to any package log. The tasks and containers in a package can be enabled for logging even if the package itself is not. Please refer to: http://msdn.microsoft.com/en-us/library/ms140246.aspx Here is a good article refer to custom logging using Event Handlers: http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/ssis_3a00_-custom-logging-using-event-handlers.aspx Thanks, Eileen Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
October 29th, 2012 3:49am

Hi KONDAPATURU, Logs are associated with packages and are configured at the package level. Each task or container in a package can log information to any package log. The tasks and containers in a package can be enabled for logging even if the package itself is not. Please refer to: http://msdn.microsoft.com/en-us/library/ms140246.aspx Here is a good article refer to custom logging using Event Handlers: http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/ssis_3a00_-custom-logging-using-event-handlers.aspx Thanks, Eileen Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2012 4:09am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics