Hi eb
Seems like some funny credentials problem(?):
I am trying to connect and load an excel sheet in to a sql server table.
Executing the dts package directly works just fine but running the same
package as scheduled job fails.
The error message says - either the excel file is opened exclusivly by
another user or this user does not have credentials
necessary to open the excel file.
Since i can open that file when executing the dts directly the first option
(file is locked for further readers) is not likely.
But the second one does not make sense also because the same user is running
both sql server, sql server agent and is also the owner
of that dts.

I am using sql server 2000 sp3a on w2k server.

Any idea how to bypass this problem,if not solve it, will be appriciatit!!

TIA

Rea

Rea,

Open task manager to see in Processes tab whether you have a run away Excel
on the background. If you do, kill it.

Ilya

"Rea Peleg" <rea_p (AT) afek (DOT) co.il> wrote

And if you schedule OLE automation fo Excel, also schedule a kill excel.exe
job to keep you server clean.


"Ilya Margolin" <ilya_no_spam_ (AT) unapen (DOT) com> wrote