Top Posts & Pages
- MAT (Moving Annual Total), YTD (Year to date) calculation using BottomCount, Tail, Properties function in MDX
- Dynamic Column Mapping in SSIS : Part 1
- Dynamic Column Mapping in SSIS : Part 2 (using dts variable)
- Restore SQL Server database using SAS from Azure Blob Storage
- Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#
-
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
