I have a dts package which gets data from the Access database located on
another box and imports it into the sql server.

If you schedule the package then the scheduler creates job which fail when
it attempts to run.
The package owner and the job owner is the same account on the SQL Server
box.The package runs fine when started manually while logged in as the same
account as package owner/job owner - and fails when ran as a job.

The log gives the following error:
Step Error Source: Microsoft JET Database Engine
Step Error Description:'F:\Bla.mdb' 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.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:5003044

Remember DTS is a client side tool. F sounds like a mapped drive? When the
package is run the Agent may have no idea what F:\ is. Can you use UNC
Paths?

http://support.microsoft.com/?kbid=269074

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"ilona" <ilona_scrambled (AT) no-go (DOT) com> wrote