Tag Archives: oledb provider

SQL Server Agent needs to Log on As Local System for using Oracle Oledb Provider in SSIS Job

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 … Continue reading

Posted in SSIS (SQL Server Integration Service) | Tagged , , , , , | Leave a comment