I'm getting an error when running my SSIS package in a SQLAgent job....
Message
Executed as user: DOITLHHQSQLT01\SYSTEM. The process could not be created for step 1 of job 0x35D6B42101FB6646B20036599D407110 (reason: The system cannot find the file specified). The step failed.
This is the command line executing the SSIS package....
/SQL "\ES Packages\ES DEDUCTIONS" /SERVER DOITLHHQSQLT01 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /LOGGER "{6AA833A1-E4B2-4431-831B-DE695049DC61}";DestinationConnectionOLEDB
I'm assuming the file it cannot find is the SSIS package..."\ES Packages\ES DEDUCTIONS".
The step is running under the SQL Agent Service Account.
Anyone have any hints for me The file is there when I look in integration services.
PS. I looked at the Configuration Manager and Integration Services in running under the Network Service account while the SQL Agent service is running under the Local System account. Could this make a difference Should all the services be running under the same account (I don't install this stuff so excuse my ignorance.)
SSIS job cannot find file....
pinchy
KasperWessing
Could you tell me how and where you set the "rely on server storage and roles access" I'm having the same problem and I'm pulling my hair now as why it won't work.
Thank you for your help!
Ron J51027