Lempster (10/2/2014)
Koen Verbeeck (10/2/2014)
Phil Parkin (10/2/2014)
Does the account executing the package have access (and permission) to the Excel file?
If it's on a local drive on the server, I would not expect it to be a permissions problem. Or perhaps you know otherwise?
Does the SQL Server Agent account have permission to all local folders?
Exactly what I was going to ask!
Ha! One step ahead of you 😛
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP