Getting error while trying to upload the data in excel from SSIS package through sql agent job

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

January 19th, 2015 7:03am

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:

  1. Validate that the account has permissions on the file and the folder.
  2. Verify that the file and the data source name (DSN) are not marked as Exclusive.
  3. Make sure SQL Server Agent Services service account has the permission to access the database.

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

Free Windows Admin Tool Kit Click here and download it now
January 20th, 2015 5:23am

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

January 20th, 2015 6:43am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics