This issue has persisted following a full uninstall and reinstall of SQL 2000
and all components.

I get the error ONLY when I try to schedule the SQL Agent to process a DTS
package containing an OLAP processing task;

(DSO (80004005): Automation error The specified module could not be found. )

.... but I can manually execute the package when I'm logged in as the same
Windows local administrator account as the SQL Agent is using... I can also
run the package from the command line with DTSRun.

The server is Windows 2003 (no SP), with SQL 2000 Enterprise, patched up to
SP3a, with the 8.00.0859 KB patch for Reporting Services on top.

I'm assuming its a .dll error, or permissions/profile issue. I've tried
running the SQL Agent under my personal account, and running it as local
system.

Where does the SQL Agent find the ActiveX components it requires when
executing DTS packages? .. they're binaries stored somewhere in msdb aren't
they?

Any thoughts gratefully appreciated.

For anyone who experiences something similar this has been resolved. It was
identified that the MDAC had been re-installed somehow under a user's login,
onto to a remote windows profile server. Quite how, I don't understand.

The relevant files are part of the Common Files\Microsoft Shared, and Common
Files\System shared dll's set.

This was resolved by copying the files to the correct location on the C:
drive, and performing a manual registry update to the key HKLM\Microsoft\
Windows\CurrentVersion\SharedDlls, as MDAC 2.8 cannot apparently be
independently installed on a Windows 2003 server (I haven't tried to see, the
release notes just say its not supported).

The best guide for the required components is the Microsoft "redist" details

http://download.microsoft.com/download/d/1/4/d14a40a7-a443-4172-a761-985bd6424538/MSDE_redist.txt


Reuben

--