Why not use SQL Enterprise Manager Data Transformation Services? You can
create a workflow to execute the next package based on the results of a
previous package. You can then save that and schedule it to run whenever.
Plus you will have a nice visual representation of what's going on. The
Execute Package option is one of the tasks. You could even try saving the
results as a file to run.

--
************************************************** *****************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1 (AT) NOMORESPAM (DOT) yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

This posting is provided "as is" with no warranties
and confers no rights.

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

You create a Global Variable Rowset of package names

Enumerating DTS Packages using VB.Net
(http://www.sqldts.com/default.aspx?250)

You can execute this stored proc in an ExecuteSQL task

You can then plug that into an Active Script task which will loop over the
rowset and execute each package based on the name retrieved

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


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