richard.maw (6/17/2010)

---

Interesting stuff but I tried adding "waitfor delay '00:00:01';" to each of the sample work SQL tasks in the OnePackageMethod (before the update statement). That way you can see what is happening because the work takes longer. On my workstation I observed that none of the tasks executed concurrently. They each execute in turn. Maybe on a server it would behave differently?

richard.maw (6/17/2010)

---

I have dual core and 4GB. When I get the chance I'll try using a remote SQL Server that should help.

Mike Dougherty (6/17/2010)

---

This works very well for centralizing a task comprised of steps on remote servers. A package to manage the remote calls has very little overhead on the machine running the package. In our usage there's a server at corporate that calls many colo-hosted SQL instances.