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

This error would suggest to me one of two articles of relevance (remember DTS
is all about the client)

http://support.microsoft.com/?kbid=288910

http://www.sqldts.com/default.aspx?223


Let us know how you get on



"Andreas Macke" wrote:

Allan,
thanks for your response. Not sure I get it, though. Looking through those
two articles, they suggest that there might be a problem with client
incompatibility. I guess I'm not sure which client executes the client in the
two separate cases - manual execution (from Enterprise Manager) vs. scheduled
(from SQL Server Agent).

The task is a standard transformation, so it's not a custom task. SQL Server
2000 SP3 was used in creating the task; it's the same SQL server instance on
which it is run (manually) and attempted to run (via schedule).

I must be missing something here. Is there any way to get more logging
detail, so as to get a better idea of what's going on? Is there another way I
could try to kick off this task? I wish I had more information; both to try
and figure it out myself and to give more meat in my request for help.

I guess I'll play with maybe making this something to be run from the
command line; see if that does anything different.

Thanks,
Andreas

"Allan Mitchell" wrote:

Update - I'm able to run the dts from the rundts command line, so I've worked
around the issue for now by simply scheduling a batch file through Windows
2000 Scheduled Tasks. Not very elegant, but at least it works for now.

I'd still love to know what's going on with this, so if anyone has any
ideas...

Thanks,
Andreas