How do I capture DTS OnProgress events from Execute Package tasks?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Rich,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to display progress of a DTS
package which contains some child packages. If there is any
misunderstanding, please feel free to let me know.

As far as I know, the child DTS events cannot be get in C#. Because the
parent DTS package was executed without break. And the DTSPackage COM
library didn't expose that use us. So the whole execution progress of the
DTS package is transparent to us. We cannot get child events.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Back
Top