sql server dts: Hi,

I've set up a new server, win2003 + SQL2000 SP4. No way to create or edit a
DTS, I've got an error in the MMC:
1'st pop up: error creating a DTS (then ok)
2nd pop ub: impossible to open selected dts. DTS designer has been closed

( it's a french to english adaptation :) )

any clue how to fix it?

thanx

bruno

Hello Bruno,

[quoted text, click to view]

this is an old post for SQL Server 7.0, but perhaps you could find something
good for your problem. Wel,I would try to (re)register the indicated dlls.

Bye

[quoted text, click to view]

Sorry, i missed the link; anyway this should be better

http://www.sqldts.com/default.aspx?225

Bye

Hi,

thanks.

It was a dll registering pb like the one described in your link, with
another pb: no way to register some dll or unregister (forbiden in the
registry).

I found this on the web. i don't remember where (so if it's your tip, thanks
a lot)
_______________________
Star|Run|cmd.exe - Change Directory (CD) to c:\winnt\system32 and run
following commands:

{

Regsvr32 /u Comcat.dll

Regsvr32 /u dtsffile.dll

Regsvr32 /u dtspkg.dll

Regsvr32 /u dtspump.dll

Regsvr32 /u dtsui.dll

}

followed by:

{

Regsvr32 Comcat.dll

Regsvr32 dtsffile.dll

Regsvr32 dtspkg.dll

Regsvr32 dtspump.dll

Regsvr32 dtsui.dll

}

Test DTS.

If unregistering/registering the dll fails then make sure your account
(that is running the commands) has proper permissions.

For example:
{

Regsvr32 /u failing for dtspkg.dll and dtspump.dll with Error code
0x80020009

Regsvr32 failing for dtspkg.dll and dtspump.dll with Error code 0x8002801c

}

indicates insufficient permissions (even Administrators can have
permissions denied to them <g>).
Attempts to resolve:
{

Open regedt32.
Highlight Hkey_Classes_Root/TypeLib.
Click the "Security" menu, select permissions.

Ensure everyone has Full Control.

Add Administrators and System --> Full Control and select it to apply to
this key and subkeys.

Reboot server.

Test DTS.

Log in as Local Administrator.

Try unregistering dtspkg.dll and dtspump.dll. They may fail with Error code
0x80020009.

Try registering the dlls (as above).

Test DTS.

}



_____________________


well, it works now.

Bruno

"Davide" <rossetti71@gmail.com> a écrit dans le message de news:
1152304262.974590.287360@p79g2000cwp.googlegroups.com...
[quoted text, click to view]