Re: Task progress when executing a package via ActiveX

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 02/18/05


Date: Fri, 18 Feb 2005 23:49:15 +0000

In message <1108761302.004698.312790@f14g2000cwb.googlegroups.com>,
camler <clerner239@hotmail.com> writes
>I am running a package from within another package using ActiveX
>script. Everything works fine (global variables are passed and set
>between both packages as expected). Can the execution status dialog
>show the progress of a child package's tasks (list each task and the
>progress)? Any ideas on how to do this or can it be done
>programatically? Only one task show in the dialog for the entire child
>package and it would be helpful to see each child task as executed.
>
>Thanks,
>Cammy
>

No. This cannot be done, as the dialog shows tasks in the package loaded
directly in the designer. There is no way for the "dialog" to enumerate
tasks in a child package it has no knowledge of.

-- 
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org


Relevant Pages