How to find which child package failed in a master package in ssis if Execute Package Task in it runs parallel
Dear Experts,
I have a master package which runs the child package. I called the child packages using Execute Package Task and all are kept in a sequence container and if I run the master package all the child packages runs and if it happens some child packages to
fail how can I get the in formation, pls provide me the solutionkarthikeyan
April 7th, 2011 9:27am
You should implement logging at the parent package level and better inside each child package to catch more info on what went wrong.
Implementing Logging - a Walkthrough: http://www.scribd.com/doc/31371774/SSIS-Logging-Implementation
Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2011 9:38am