Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2006-10-27 : 18:13:44
|
Hey all,I created a dts package to export from a view to an Access DB.I can right click on the package and it runs fine.But when I go to schedule the job and run it through SQLAgent\scheduler I get the error:(All file names and directories have been changed for security purpose  )Executed as user: Test\SQLuser. ... Executing... DTSRun OnStart: Delete from Table DLInfo Step DTSRun OnError: Delete from Table DLInfo Step, Error = -2147467259 (80004005) Error string: The Microsoft Jet database engine cannot open the file '\\west\public$\DLInfo.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Error source: Microsoft JET Database Engine Help file: Help context: 5003051 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -534709256 (E020FBF8) Error string: The Microsoft Jet database engine cannot open the file '\\west\public$\DLInfo.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Error source: Microsoft JET Database Engine Help file: . The step failed.I gave the SQLAgent service startup acct Test\SQLUser domain admin privledges because I thought it was a permissions error.Any suggestions?Thanks for your helpR/P |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-10-27 : 19:02:39
|
| What happened when you logged onto the SQL Server under the SQLAgent service startup account and ran the package?CODO ERGO SUM |
 |
|
|
|
|
|
DTS To Access Error