Top Posts & Pages
-
Recent Posts
Categories
Tag Archives: agent
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 agent, job, job hangs, oledb provider, permission problem, SQL server
|
Leave a comment
