This problem was one of the most terrible one in my short SSIS career. I was using a script task which uses Oracle Oledb provider to connect to an oracle server. After the package was complete, I created a SQL server job and obviously the job’s step was configured to run from SQL Server Agent … More SQL Server Agent needs to Log on As Local System for using Oracle Oledb Provider in SSIS Job