I have some jobs that for some reason are failing but if i run them manually they work. It has to be on the agent side that is causing the issue but i am unsure where to start. Other jobs on same server are running over night with out failing.

It appears that the SQL Agent service account doesn't have permissions to the resources(databases or files etc) required by the package. Can you verify that?Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

Hi Chaunnah, When you see a SSIS package fails running in a SQL Agent job, you need to first consider the following conditions: 1. The user account that is used to run the package under SQL Server Agent differs from the original package author. 2. The user account does not have the required permissions to make connections or to access resources outside the SSIS package just as Shahfaisal said. You can find the detailed information in this KB article: An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step http://support.microsoft.com/kb/918760 For more details about how to troubleshoot the issue, please refer to: http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e13c137c-1535-4475-8c2f-c7e6e7d125fc Thanks, Eileen

Hello, Please follow the links below for more help. http://www.codeproject.com/Articles/14401/How-to-Schedule-and-Run-a-SSIS-package-DTS-Job-in http://blog.sqlauthority.com/2011/05/23/sql-server-running-ssis-package-in-scheduled-job/

Hello, Check out the links below. It may help oyu. http://blog.sqlauthority.com/2011/05/23/sql-server-running-ssis-package-in-scheduled-job/ http://www.codeproject.com/Articles/14401/How-to-Schedule-and-Run-a-SSIS-package-DTS-Job-in