Jeff thank you that makes sense. I will test this here shortly (or possibly tomorrow as I am getting sleepy!) and run some tests on the OPENQUERY. If run into any hiccups with that I will let you know.

And yes in regards to the jobs running concurrently, I have done quite a lot of extensive testing, it is pretty much 9 tables that are 95% of the data, the rest are much smaller tables so I pretty much run the first 9 in serial, then the rest in a parallel chain.

I will need to figure out a way to figure out how to execute the next batch of jobs once the first batch completes, but I guess one step at a time 🙂

Robert I will give this a whirl as well and weigh the value of both methods to see which will be best for my company. Since we have all these SSIS packages in place I am leaning toward that, but if Jeff's solution tends to be world changing, I may still be swayed that way 😉