Today I tried setting all the SQL tasks to Read Uncommitted but that didn't help either. I'm holding off on resorting to putting presidences between all the execute package calls in the master package as this basically kills the parallel processing the team is after. The random-ness of the hanging or failure of SQL tasks that work one time and not the next is strange.