It's the Database!!! (3/20/2013)

---

lazy writer (3/20/2013)

---

Hi,

I had some weird issues while running SSIS package as agent job. I can run SSIS package manually but failing to run as agent job. I thought its permission issues with Agent service account then I RDP into the server using service account login (domain\agentserviceaccount) and run the package and it went fine.

any idea?

much appreciated 🙂

Thanks

You need to have the package encryted with the user. you can open and save it all day however if you do not encrypt it won't save and it will fail.