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

---

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

I capture my error messages.

This is an example when the password was not stored:

OLE DB provider "MSDASQL" for linked server "LS_RDB_DWH_POLICY" returned message "[Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied ".

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.

see this link for more detail...

http://www.mssqltips.com/sqlservertip/2091/securing-your-ssis-packages-using-package-protection-level/