DTS schedule job 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!

 

[mrdenny]

Sounds like the server doesn't have the FoxPro 8 driver installed or setup correctly.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Steffi1013]

But why can I run it directly through DTS but the scheduler fail - is that caused by the driver??

 

[SQLDenis]

That's because when you run it manually it uses the drivers from your machine

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Steffi1013]

Thank you -- now I will just need to find the driver for FoxPro 8 and load it onto my server --- oh, yippee!

 

[Steffi1013]

Do you know what drivers I would need to load??

 

[mrdenny]

You'll probably need to ask the folks in the foxpro forum.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com