Evil Kraig F (12/19/2013)
SSIS however is awesome for laying out processing methodology and calling sequential procedures with obvious and self-documenting logic pathing, however. There's plenty of other things it can do but I find a single package controlling a complete task to be very easy to read without having to dig through code to find the control pass points or dig through signficantly complex if trees.
Now THAT I agree with. It's also a heck of a lot easier to run things "in parallel" than it is with T-SQL.
--Jeff Moden
Change is inevitable... Change for the better is not.