468,110 Members | 1,856 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,110 developers. It's quick & easy.

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

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
Jul 21 '05 #1
2 2605
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."

Jul 21 '05 #2
Thanks.

"Kevin Yu [MSFT]" wrote:
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."

Jul 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by aimee | last post: by
23 posts views Thread by pamelafluente | last post: by
5 posts views Thread by =?Utf-8?B?QW50?= | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.