Re: Task progress when executing a package via ActiveX
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 02/22/05
- Next message: Darren Green: "Re: csv to multiple tables"
- Previous message: Ali-R: "csv to multiple tables"
- In reply to: camler: "Re: Task progress when executing a package via ActiveX"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 22 Feb 2005 22:12:06 +0000
In message <1109087138.761224.167020@f14g2000cwb.googlegroups.com>,
camler <clerner239@hotmail.com> writes
>I may be way off, but do you think you might be able to use the
>OnProgress event of the child package to update the dialog window of
>the parent package (WinForms or something)? Possibly changing
>properties or adding items to the dialog displayed?
>Just a thought.
>
>Thanks
>
The on progress event of a task, not a package, allows you to tell it
how far that task has got, which is what gives you the row counts or %
complete. This is at a task level however, and does not allow you to add
new lines to the dialog. If you wrote your own execute process task you
maybe able to give it some more meaningful progress info, but this is
still just one number for the entire child package.
The dialog is not exposed, and initial population is beyond your
control. The only way to do this would be to write your own execution
control, for the dialog, and your own execute package task that passed
up child events in a format the custom dialog could interpret. Still
almost impossible due to the way packages can change during execution,
so any initial investigation of the package and it's children, which
would be required to populate your custom dialog to start with, but may
not hold true during execution as you could change the child package
that was to be executed for example.
Try and think of DTS as a non-interactive tool, it may help :)
-- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org
- Next message: Darren Green: "Re: csv to multiple tables"
- Previous message: Ali-R: "csv to multiple tables"
- In reply to: camler: "Re: Task progress when executing a package via ActiveX"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
