SSIS packages fail with Pending Execution Status
If the packages are running as part of a SQLAgent job, check the job for what user it's running as.  Check those permissions, and that could be your problem.  I just had to repair a situation like that.  Permissions got yanked from the wrong users, and it broke everything...