DTS Error

I am using DTS packages to import data from a foxpro database into
my sql server database. When i execute the DTS package, everything
works great and the import is successful. (I am using OLE DB Providers).

However, when i schedule a DTS package to run automatically, the job fails.
Manually executing it is successful.

Any help is appreciated.

Here is the error displayed in the Job History.


[SpeedyWeb].[dbo].[DailyTran] 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); Provider Error: 0 (0) Error string: Invalid class string
Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100
Error: -2147221005 (800401F3); Provider Error: 0 (0) Error string: Invalid class string
Error source: Microsoft Data Transformation Services (DTS) Package He. The step failed.

Try viewing the package log to determine what it failed on.

I dont see any logs when i check the package logs...how do i enable
package logging. Also, some site suggested something about registering
DTS packages, how do i go about it?

Thanks

Ok, I enabled the package logs. They list the same error.
Any ideas?

Basically, the DTS package imports the data from a FoxPro
database on a connected computer of a peer-to-peer LAN.
Is this because of some account permissions. In the manual
DTS import i am using my "Admin" account. What account
does the automated scheduled DTS use?

It would use whatever account you have setup for the connection.