SQL Server 2005 Agent running SSIS job can't find file path

Posted by alimack on Server Fault See other posts from Server Fault or by alimack
Published on 2010-04-13T12:43:30Z Indexed on 2010/04/13 12:53 UTC
Read the original article Hit count: 387

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 Management\Monthly Absence.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."

I've tried using UNC paths (\servername\ share) but the BIDS rewrites the paths to standard file paths (c:\directory\filename), I've also tried a proxy which runs this step under an Admin account. I've also tried changing the path to UNC on the SSIS job on the server. Also I'm forcing it to use the 32 bit DTEXEC, so it's not that either

Always get the same error, do I need to re-create the job from scratch?

© Server Fault or respective owner

Related posts about sql-server-2005

Related posts about ssis