I have a DTS Package that imports to SQL Serer (2K sp3) from older
dBase files. The package works fine if executed manually. When executed
via SQL Server Agent (runs under domain account) - I get a series of
errors:

DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259
(80004005)
Error string: External table is not in the expected format.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003274

Error Detail Records:

Error: -2147467259 (80004005); Provider Error: -328602519 (EC69EC69)
Error string: External table is not in the expected format.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003274

It is not a permissions issue, I can log on as the domain account for
SQL Server and run the package manually just fine.

Help, please.

I have also tried changing the driver to: dBase 5.0 , dBase IV and
dBase III as well as System DSNs using VFP drivers (which don't see all
of the tables (files).

I just want to pursue the permissions thing further as the error

80004005

says that you either typed something incorrectly or it indeed cannot see the
data.

What "runs under domain account"? The SQL Server Agent Service?
Who owns the job? A member of sysadmin?

can everybody see the DSN?

http://support.microsoft.com/default...;en-us;Q238431


<jmblock101 (AT) gmail (DOT) com> wrote

Not a sql server issue .. turns out I needed BDE on the server.