On my SQL 2K development system when I open the DTS package I get a
DTS designer error. Further, all tasks in DTS are totally missing and
further even the transform task does not work.

I tried completely uninstalling SQL and reinstalling SQL still the
same problem.

Is there a good free uninstaller to cleanup a application completely.

Thanks
Simon

I would try

Reregistering the DTS dlls
Reinstalling MDAC


Has it ever woked?
Did you install something else on there and now it doesn't work?

--

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

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"Simon Lenn" <simonlenn (AT) yahoo (DOT) com> wrote

Another option is to install a named instance of SQL Server 2000. This will
force a complete rewrite of the DTS components. I do not believe they all
get removed when SQL Server is unistalled. If this fixes the problem, you
can then remove this instance without affecting DTS.

Rand
This posting is provided "as is" with no warranties and confers no rights.

rboyd (AT) onlinemicrosoft (DOT) com (Rand Boyd [MSFT]) wrote in message news:<y7FTjj$REHA.2260 (AT) cpmsftngxa10 (DOT) phx.gbl>...
How can i reregister the DTS dlls and how do I reinstall the MDAC.

Also, how do I create a different named instance I thought SQL sets it
up by default to the server name.

Thanks
Simon