My goal is to execute a DTS package that calls multiple child DTS packages
from a C# (2003) app and display the progress of the entire process to the
user.
I have followed the model defined in this knowledge base article. (
http://support.microsoft.com/?id=319985 ) to execute a DTS package and
monitor it's events. I'm not able to capture the events from a child package
that is called from an Execute Package task.
I've seen a few different writeups on the web that say it can't be done, and
some that say you need to create custom tasks on the main thread to capture
these events. I assume that this can be done because when I execute the
parent package through dtsrun, it returns output that reads "OnProgress " and
displays info about the child package.
Does anyone have an example of one of these custom tasks or have another
alternative solution?
Thanks
Rich