Hi,

I am having a very weird error problem. I run a DTS package which produces
an XML file from running a stored procedure. If I run this through the
Console window it runs fine. I have setup another stored procedure using
sp_OACreate, sp_OAMethod to run it. Now it sets everything up fine. However,
on the .Execute line for the Stored Procedure it errors with :

Error on Line 19

(Microsoft XML Extensions to SQL Server (80004005): Failed to instantiate a
class object from MSXML3.DLL. The correct version of this DLL is missing or
not registered properly)

Step Error code: 800403FE

Step Error Help File:sqldts80.hlp

Step Error Help Context ID:4500

Now MSXML3.DLL is installed and registered. I've uninstalled msxml4.dll and
re-registered msxml3.dll. I've tried using none versioned DOMDocument as the
create object. This causes a scripting error trying to instantiate the
object.

Any insights or suggestions most welcomed.