All,

Is it possible to execute task in a task. For example my ActiveX Task sets
global variable in a loop and other task (in the same package) reads the
environment variable (server name) and queries the server for specific data.

My problem is I'm not able to execute the DynamicPropertiesTask using object
model. Does anybody have an sample code on how to execute task in a task ?

Thanks,
-HKM

I have never done it but have also never had the need to cherry pick tasks
out of a package like this. Can you not use workflow to do this and make
sure that the DP task is first

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"HKM" <HKM (AT) discussions (DOT) microsoft.com> wrote