> We have a very simple DTS package to import data from a Paradox 4.x
> database
> into SQL server. When the package is executed directly it works fine.
> When it is run as an sql server agent job it errors with "Microsoft
> JET
> Database Engine" reporting "External table is not in the expected
> format."
> As an Access developer I'm slightly confused to see the Access JET
> engine complaining about a paradox database?
>
> The package has one connection set to Paradox 4.X and one connection
> as the SQL server with a simple copy data transformation in between.
>
> Full error text is:
> Executed as user: SILVERSTONE\Administrator. DTSRun: Loading...
> DTSRun:
> Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
> OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: Copy Data
> from
> PART to [Parts].[dbo].[PartsFiles] Step DTSRun OnError: Copy Data
> from
> PART to [Parts].[dbo].[PartsFiles] Step, 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 DTSRun
> OnFinish:
> Copy Data from PART to [Parts].[dbo].[PartsFiles] Step DTSRun:
> Package
> execution complete. Process Exit Code 1. The step failed

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:f0343b03146dc8c7f947ee57d090@msnews.microsoft.com...
> Hello Andrew,
>
> Usually when something works interactively and not as a job then the
> answer lies within here
>
> http://support.microsoft.com/?kbid=269074
>
> Also have a look here for the Paradox and jet thing
>
> http://support.microsoft.com/kb/230126/EN-US/
>
>
> Allan Mitchell
> www.SQLDTS.com
> www.SQLIS.com
> www.Konesans.com
>
>> We have a very simple DTS package to import data from a Paradox 4.x
>> database
>> into SQL server. When the package is executed directly it works fine.
>> When it is run as an sql server agent job it errors with "Microsoft
>> JET
>> Database Engine" reporting "External table is not in the expected
>> format."
>> As an Access developer I'm slightly confused to see the Access JET
>> engine complaining about a paradox database?
>>
>> The package has one connection set to Paradox 4.X and one connection
>> as the SQL server with a simple copy data transformation in between.
>>
>> Full error text is:
>> Executed as user: SILVERSTONE\Administrator. DTSRun: Loading...
>> DTSRun:
>> Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
>> OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: Copy Data
>> from
>> PART to [Parts].[dbo].[PartsFiles] Step DTSRun OnError: Copy Data
>> from
>> PART to [Parts].[dbo].[PartsFiles] Step, 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 DTSRun
>> OnFinish:
>> Copy Data from PART to [Parts].[dbo].[PartsFiles] Step DTSRun:
>> Package
>> execution complete. Process Exit Code 1. The step failed.
>
>