Home Forums SQL Server 2005 Administering ssis package not working with sql server agent but run fine manually RE: ssis package not working with sql server agent but run fine manually

  • It has been a while since I had to deal with this myself, but as I recall if you need to run the process under an account with logon local windows permission granted in policies. If you are running under a system account or Agent account you don't want to have that right, then look at using a proxy account for Agent to execute the job under.