hello guys i have a dts package to drop pluhist in the sql server and grab
another pluhist table from db5 from aanother computer, i have sceduled this
task to run every 15 minutes.

unfortunately this scedule doesnt work. It drops the table recreate the
table but doesnt pull any data. but if i manually execute this it workds
fine...

in the sql server i found out the following error


Executed as user: PRIM-SQL\SYSTEM. ...Start: Drop table pluhist Step
DTSRun OnFinish: Drop table pluhist Step DTSRun OnStart: Create Table
pluhist Step DTSRun OnFinish: Create Table pluhist Step DTSRun OnStart:
Copy Data from Results to pluhist Step DTSRun OnError: Copy Data from
Results to pluhist Step, Error = -2147467259 (80004005) Error string:
'\\8850stc\C\fbase' 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. Error source: Microsoft JET Database Engine Help file:
Help context: 5003044 Error Detail Records: Error:
-2147467259 (80004005); Provider Error: -534774783 (E01FFC01) Error
string: '\\8850stc\C\fbase' 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. Error source: Microsoft JET Database Engine Help
file: ... Process Exit Code 1. The step failed.



can some one please tell me what the heck is going on as i am totally lost..


kind regards

las

Check the SQL Agent service account. If you are accessing
network resources in jobs (such as this DTS job), you need
to have the service account be a domain account.
Additionally, the account needs the appropriate permissions
to access \\8850stc\C\fbase
You can find troubleshooting steps for problems when a
package doesn't run when scheduled in the following:
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?id=269074

-Sue

On Sun, 22 Aug 2004 19:45:04 -0700, Las
<Las (AT) discussions (DOT) microsoft.com> wrote: