SQL Server 2005 Agent running SSIS job can't find file path
- by alimack
Basically I'm trying to run a functioning SSIS job (created in BIDS) under the SQL Server Agent - it reads a set of Excel spreadsheets and dumps the results into a table.
The problem I'm having is getting the SSA to read the file path, the relevant part of the error is:
"0x80004005 Description: "'N:\Assets Property & Facilities…