This is driving me crazy now, any help is great appreciated:
I have a SSIS package for importing data from an Excel file to a SQL 2005 database:
1. Check to see if the Excel file exists (fixed name Excel file on another internal network folder)
2. If #1 returns true, import data; if not, exit.
If I run the package directly, it works fine, but if I schedule a job to run the package, the job can still run successfully, BUT step 1 in SSIS always return false, i.e. step 2 in SSIS will never been executed.
Looking at the log, I found that the step 1 in the SSIS package always retuened false because accessing the Excel file was denied, I’ve tried to give the network folder FULL permission to even EVERYONE, but it still doesn’t work.
What I missed?
Code: 0xC0202009 Source: TrackingDataImport Connection manager “SourceConnectionExcel” Description: SSIS Error Code DTS_E_OLEDBERROR.
An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: “Microsoft JET Database Engine” Hresult: 0x80004005 Description: “The Microsoft Jet database engine cannot open the file ‘\\MyNetworkFolder\ExcelData.xls’. It is already opened exclusively by another user or you need permission to view its data.”. End Error