SSIS: Unable to Read from Excel file from a UNC path when deployed to server

I appear to be unable to get my deployed SSIS package to read from a 1997-2003 Excel file. I get stuck with the following 2 errors:

SSIS Error Code DTS_E_OLEDBERROR, Error code: 0x80004005 An OLE DB record is available. Source Microsoft JET Database Engine, database engine cannot open the file, it is already opened exclusively by another user, or you need permission to view its data.

DTS_E_CANNOTAQUIRECONNECTIONFROMCONNECTIONMANAGER with Error code 0xC0202009

The package itself works with no issues when using SQL data tools on the server logged in as the service account only when deployed to server I see this issue.

To make this issue even more confusing I have setup and tried the following:

• Runtime is set to 32 bit on the debugging menu on SQL data tools as well as the job configuration is set to use 32 bit runtime
• I am able to UNC to the folder/file when logged in as the SQL service account

Any Ideas?

Thanks, M

I figured it out in the end. Turns out I missed a step with the permissions.

Yes the Service account had permissions to the folder but I failed to add read permissions to the file itself.

Thanks for all comments/suggestions.

M