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??
I configured the package using SQLSERVER Configuration type.
Thanks in Advance.