Click here to Skip to main content
15,885,546 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
HI All,
I have a SSIS package which Imports data from Excel to database.I added this package to execute as a SQL Agent Job.When I am running the package as a job I am able to run it successfully.When I run the package from Visual Studio I am getting error saying...

"Code:0xC0202009 Source:User Connection manager " Excel Connection manager" Description: SSIS Error Code DTS_E_OLEDBERROR + Source:"Microsoft Jet database engine" Hresult: 0x80004005 Description: "the microsoft jet database engine cannot open the file".Its is already opened exclusively by another user,or you need permission to view its data".
Adding to this,I am getting this error when I logged as a user,other than the Admin who created the package.This package is working fine for the admin login.
My question here is why only user is able to get the excution with out failure???
Please find me the correct solution ..
Am I missing any permissions??
FYI,
I configured the package using SQLSERVER Configuration type.
Thanks in Advance.
Posted

1 solution

Check which user the SLQ Agent is running? It should also have admin privileges...

Thanks
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900