DTS - can't run as scheduled task

From: Andreas Macke (AndreasMacke_at_discussions.microsoft.com)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 14:03:05 -0800

SQL Server 2000, Enterprise Manager
Windows 2000

I have a dts package that runs like a charm when kicked off manually. When
trying to kick it off via a schedule, it creates a logged error (see below).

I'm not sure how to troubleshoot this. The tasks that are bombing are
reading Visual FoxPro 7 files (.dbf), transforming them, and then doing
inserts into SQL Server tables. The files are accessible to all adminstrators
on that box, just like the SQL Server data files.

When running manually, I'm running from the same box, so I'm thinking it's
not a matter of missing dll's.

Any other ideas?

Thanks,
Andreas

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

Relevant Pages
Loading