gurvimail (3/25/2013)
My connection string looks like this for excel, so if the user with the services account exists in the server then it should be able to acces the file., i am confused on this.Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\"Here i provide the path"';Extended Properties="EXCEL 12.0 XML;HDR=YES";
Yes. FOr Excel connection strings there is no other option other than to have the Windows User executing the SSIS Package to have been granted access to the file specified in the Data Source, i.e. there is no way to provide a username or password in an Excel OLE DB Connection String either for the UNC access nor the Excel Spreadsheet password (if there is one which you said there isn't).
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato