Hello Ramu,
I guess the Service account of SQL Server-Agent don't have permissions to Access the file on the Network share. Use a SQL Server Agent-Proxy account with sufficent permissions: Creating SQL Server Agent Proxies
Technology Tips and News
Hello Ramu,
I guess the Service account of SQL Server-Agent don't have permissions to Access the file on the Network share. Use a SQL Server Agent-Proxy account with sufficent permissions: Creating SQL Server Agent Proxies
Hi Dikshan Gade,
According to your description, you want to upload data from excel to database, when you call ssis package through SQL Server Agent job, you got the error message.
To troubleshoot the problem, please refer to the following steps:
We can check SQL Server Agents activity logs, Windows Event logs and SSIS logs to get more clues. Also the tool Process Monitor is helpful to track the cause of registry or file access related issues. For more information about the issue, please refer to
the following KB article:
http://support.microsoft.com/kb/306269
If you have any more questions, please feel free to ask.
Thanks,
Wendy Fu
We are getting below errors.
Error:
The Microsoft Jet database engine cannot open the file '\\serversdev\Documents\QC Files\Prod.xls'. It is already opened exclusively by another
user, or you need permission to view its data.
Please suggest ASAP
Regards,
Ramu