Phillip.Putzback (1/20/2014)
...since some of the procedures I was given take so long to complete
Actually, from what I saw of the process path in your SSIS graphics and unless they're playing against,say, DB2 linked servers, I was going to suggest that the underlying stored procedures need some work for performance.
--Jeff Moden
Change is inevitable... Change for the better is not.