Hi,

I want to setup a task to run about 50 small ssis packages. What's the easy
way to do so? I can create a new job and specific one package at a job but
that seems a lil' tedious. Is that the only way?

I'm new w/ SQL in general btw. Thanks!

Hello Henry,

All stored on the file system?

If they are then create 1 master package with a ForEach loop (File) and an
ExecutePackage task. On each iteration of the loop you pass the name of
the package to the task and off you go. You could do similar with packages
in MSDB


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com