When opening a DTS package the error 'Class not Registered' error appears. When you ok the message the package opens but heaps of connection icons are missing from the left selection panel. I reinstalled SP3 but it still happens. I totally uninstalled SQLServer, checked and removed all regtistry entries then reinstalled SQLServer with SP3 and latest Security patch but I still get the error. Any Ideas?

See if this article helps

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

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jules" <anonymous (AT) discussions (DOT) microsoft.com> wrote

missing from the left selection panel. I reinstalled SP3 but it still
happens. I totally uninstalled SQLServer, checked and removed all regtistry
entries then reinstalled SQLServer with SP3 and latest Security patch but I
still get the error. Any Ideas?

I have already tried the advice listed at the link. I also uninstalled and reinstalled SQLServer and Client tools to no avail. I'm not sure what else I can try...

Try to reinstall MDAC.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jules" <anonymous (AT) discussions (DOT) microsoft.com> wrote

else I can try...

ok thanks, I will try that tomorrow. I am sick of this place for today (well evening)

Thanks Mitchel.. I installed MDAC 2.8 and all was restored.. Gawd what a nightmare..