Hi Guys,

I'm getting the below message, any ideas?

Error Source: Microsoft Data Transformation Services
(DTS) Package

Error Description:Unable to create SQL-DMO objects.
Please make sure that SQL-DMO is properly installed on
this machine.

Error code: 80040442

\Error Help File:sqldts80.hlp

Error Hel





Step Error Source: Microsoft Data Transformation Services
(DTS) Package

Step Error Description:Unable to create SQL-DMO objects.
Please make sure that SQL-DMO is properly installed on
this machine. (Microsoft SQL-DMO (80004005): [SQL-DMO]The
applicat

Executing DTS package

**** DTS ERROR Occurred ****

thanks
Richard

Try reregistering the DMO dlls

I had a similar problem when i uninstalled a version of SQL Server and left
the default on there. I went to EM and it threw a very similar error. I
reregistered SQLDMO.dll and it works again now.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Richard" <richardroy_74 (AT) hotmail (DOT) com> wrote