DTS Accessing dBase Files

  • 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!

  • 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