Could not create an instance of OLE DB SQL Schedule job fails
Posted on 2007-03-21
There is a scheduled job on our SQL server that processes in 8 steps. The first step is to copy Excel files from a template folder to populate it with the particular days date. The rest of the step invoke stored procedures . The joba wwere running ok until yesterday when the first step is successful and the rest fail.
The error for the failed steps is
"Executed as user: NT AUTHORITY\SYSTEM. Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. [SQLSTATE 42000] (Error 7302) OLE DB error trace [Non-interface error: CoCreate of DSO for Microsoft.Jet.OLEDB.4.0 returned 0x80040154]. [SQLSTATE 01000] (Error 7300). The step failed."