dbTalk Databases Forums  

Problem starting DTS Wizard

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Problem starting DTS Wizard in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
D Burk
 
Posts: n/a

Default Problem starting DTS Wizard - 02-06-2004 , 01:51 PM






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!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.