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