August 1, 2005 at 3:36 pm
I have a job that exports to an existing dbf file. If I run it manually then it will finish just fine. If I use the scheduled job to run it, it fails. Here is what Job History shows. I have full rights to the directory where the dBase file exists.
Executed as user: DOMAIN\Administrator. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_5 DTSRun OnError: DTSStep_DTSExecuteSQLTask_5, Error = -2147467259 (80004005) Error string: Unexpected error from external database driver (10049). Error source: Microsoft JET Database Engine Help file: Help context: 5003000 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -535434136 (E015EC68) Error string: Unexpected error from external database driver (10049). Error source: Microsoft JET Database Engine Help file: Help context: 5003000 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_5 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
Any ideas? Thanks!
August 1, 2005 at 10:02 pm
Unless the SQL Server instance is running under your account you need to check to ensure that it has rights to the directory in question.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply