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 |
|
joemama
Posting Yak Master
113 Posts |
 Posted - 2006-05-11 : 21:07:01
|
| i have a dts package that export information to excel...when i log on and run it manually it works fine...however when i schedule it to run when i am not logged in i get this messageStep Error Source: Microsoft JET Database EngineStep Error Description:'J:\BREAST CANCER SURVIVORSHIP\Tracking System\reports\ReportsOut\SAS_SummaryReports\Qry_SummaryReportsForExport.xls' 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: 80004005Step Error Help File:Step Error Help Context ID:5003044any clues would be helpful...i am thinking it has something to do with permissions???? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-05-12 : 00:59:09
|
| When you run it manually, you are running it as you, in the context of your desktop session.When you run it as a scheduled task, it's running as the SQL Server Agent.If J: is a mapped drive for you, The SQL Server Agent account won't be able to see it. You should use UNC paths instead of mapped drives, and make sure that your SQL Server Agent has permissions to the network.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
|
|
|
manual package works sheduled does not