SQL Server 2000
Windows 2000

I have a DTS that takes Visual FoxPro version 7 files (.dbf) and reads them
to then transform the data and load it into SQL Server.

Runs like a dream when executed manually. Fails every time when trying to
run it as a scheduled job - see logged error at the very bottom.

I'm assuming that the machine on which this is runnind has all the necessary
dll's - else, why should it run when I'm kicking it off manually on that
machine.

The files that are being accessed have the exact same permissions as the
database files sql server uses - they're open to all administrators on that
machine - that should cover the SQL Server Agent, right?

Any ideas on what this might be??


Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Invalid class string
(Microsoft Data Transformation Services (DTS) Package (800401f3): Invalid
class string
)
Step Error code: 800401F3
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100