I'm pretty new to SSIS but I've managed to cobble together a number of individual packages to refresh SQL tables from a 3rd-party database.

Now, what I'd like to do is have a single package that I can use to invoke each of the individual ones. Since it will run on a quad, I'd like to invoke them such they'll run in parallel.

Could you point me in the right direction?

Pretty simple!

Create your new package, and use the Execute Package Task component in the control flow to execute your individual tasks. Don't set precedence constraints between them, and SSIS will (to the best of its ability) execute them in parallel as resources allow.

Hi,

what about log, when more than one task finish together and try to write data into a single table.

Regards,

Manish