Hi , I have a 2 JOBS in SQL Server agent . 1.JOB Exceuting a Stored Proceedure 2.Executing an SSIS Package When i Run JOB 1 It ran very well and job was Successful , but when I run the SSIS Package under SQL Server Agent .it Fails and throws me an Login failed . But when i go to the package and run it manullay it RAN Sucessfully , Note: I used SQL SERVER AUTHENTICATION at SSIS package while connecting to Database. I am having SA Account .... Can you please tell me why cant i Exceute the SSIS package Under SQL Server Agent .

Running it manually frim BIDS? What are the resourcs being used in the package? Are any folders or other data bases being used? If thats the case(most likely) you need to run the package using proxy account with previleges to the resources used.My Blog | Ask Me

You need check your SQL Agent services account , does it have rights to exec on the server? If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer. Sevengiants.com

SQL Agent Service might not have enough permissions on the packages and folders. If the packages accessing any folders you must give the service account to access those folders.

I tried connecting to my server using 00.00.0000 (name) when i tried using Instance name it ran succesfuly Thanks for your help