DTS and FoxPro 8 Failure

[Steffi1013]

I am using DTS to import 3 tables from FoxPro 8 and when I run the DTS package manually, it works fine. When I schedule the job to run -- IT FAILS... the following error is what I receive::::


Executed as user: MRE_DOMAIN\SQLSVC. ...art: Drop table [H2O].[dbo].[posttime] Step DTSRun OnStart: Drop table [H2O].[dbo].[respchld] Step DTSRun OnStart: Drop table [H2O].[dbo].[respdet] Step DTSRun OnFinish: Drop table [H2O].[dbo].[respchld] Step DTSRun OnStart: Create Table [H2O].[dbo].[respchld] Step DTSRun OnFinish: Drop table [H2O].[dbo].[posttime] Step DTSRun OnStart: Create Table [H2O].[dbo].[posttime] Step DTSRun OnFinish: Create Table [H2O].[dbo].[respchld] Step DTSRun OnStart: Copy Data from respchld to [H2O].[dbo].[respchld] Step DTSRun OnStart: Create Table [H2O].[dbo].[respdet] Step DTSRun OnError: Copy Data from respchld to [H2O].[dbo].[respchld] Step, Error = -2147221005 (800401F3) Error string: Invalid class string Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147221005 (800401F3); Provi... Process Exit Code 3. The step failed.

PLEASE HELP!

Am I missing a driver? Do I need the FoxPro OLEDB loaded on the server?

 

[Mike Lewis]

I doubt if this is a missing driver issue. If it was, you wouldn't have got as far as you did.

The message suggests that there's something wrong with your Respchld table. You could try removing this from the package to see if the problem goes away.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[robsuttonjr]

The fact that it works manually and not automatic suggests a problem with the username/password associated with the sql service account. Also check the owner of the job. We had this very same issue.

Regards,

Rob