Recently I had a hard drive crash on my PC. After
installing a new drive and reinstalling Windows 2000 Pro I
reinstalled SQL Server 2000 Client Tools. Enterprise
Manager and Query Analyzer seem to be running fine, but
when I start the DTS Wizard I immediately get an error
dialog that states:
(Title Bar

DTA Emport/Export Wizard Error:
GetSourcesRowset
(Dialog text

Class not registered
OK button.
Upon clicking OK the Wizard appears to open, but when you
try and select a "From" Source the list is odd (incomplete
and containing some foreign text like "Driver Para o
Microsoft Visual FoxPro", etc... The Wizard then
effectively freezes and won't go any further.
It would seem that this class failed to register during
the installation. I checked the SQLSTP.LOG file and it
did show issues self-registering several DLL files.
Log syntax was like this:
11:30:16 Manual DLLRegisterServer C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\sqllex.dll: 126,
0x7e
11:30:16 The file listed below could not be registered.
Adding it to RunOnce to try again on the next reboot.
11:30:16 DLL6: C:\WINNT\System32
\regsvr32.exe /s "C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\sqllex.dll"
Actual files getting the message were:
dtsui.dll, semdts.dll, cdwtskui.dll, sqldmo.dll,
sqlns.dll, sqllex.dll, ctasksui.dll.
Everything else in the log file looks OK. I ran
regsvr32.exe for each of the DLLs using this syntax:
regsvr32.exe "C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\ctasksui.dll"
Each time I got a normal response indicating the
registration was successful.
I shut down and restarted Windows and am still having the
same problem.
I would appreciate any suggestions. I'm comfortable
editting the registry if needed, but have no idea what the
CLASS ID would be nor exactly where to load it.
You can respond to my email or here on the BBoard.
Thanks!