Hi,
I have two servers with sql2000, one with windows Nt 2000 and another with
windows server 2003.
When in the 2003 server I right-clicked on <Local Packages> in <Data
Transformation Services> and choose <new package> I got the above error
message.

I closed everything re-opened Enterprise Manager and repeated the
click-procedure.
Now I do not get an error message but the icon bars for <connection> and
<task> are missing all icons. Also the menu connection only lists: <Microsoft
data link...> and <other connection...> while the <task> menu only lists
<register custom task> and <unregister custom task> where actually these
menus should be populated with about 15 choices (=> the corresponding items
to the missing icons).

I tried to register some dlls as dtsffile.dll and dtspkg.dll in C:\Program
Files\Microsoft SQL Server\80\Tools\Binn and receive the error message:
DLLRegisterServerin ..... failed.
Return Code was: 0x8007007e
This is not even a heavy duty server. The data bases are not big and nothing
much happens that could throw the server off balance. I assume it is rather a
bug having to do with the operating system windows server 2003.
Perhaps it is due to some hot fixes from Microsoft which I applied?
In Windows 2000 DTS works fine.

Would anyone have a suggestion how to remedy the problem?
I greatly appreciate it.

The Cracks ain't answer, but I found it anyway.
So here you go, to whom ever it may concern:

Most likely the problem occurred after applying several HotFixes for Windows
2003 server as I checked all Hotfixes that would apply here:
http://www.microsoft.com/technet/security/current.aspx

Intuitively in response to the error message (no DTS tasks nor connections
anymore) I reapplied ServicePack3a for SQLServer2000.
This solved this problem, but created another.
Afterwards when opening EMgr I received two error messages:
REBBRUI.rll is missing and
Snap-In failed to initialize: Meta Data Services.

REBBRUI.rll is non-existant so the error message really leads astray.
The answer to this I found in another forum, that is here:
http://www.sqlservercentral.com/foru...ssageid=102357
(the second last and third last entries from Nicholas Cain (thanks for that,
Nicholas, it sure helped a lot!!)
For convenience I might as well note the solution here again:
Re-register the following two DLLs (If you prefer to click, like I sometimes
to: right-click the DLL, Open With, Open With, Select the program from a
list, Mark Microsoft © Register Server OR if it is not listed click Browse,
…\windows\system32, Scroll to regsvr32.exe, open, OK):
C:\Program Files\Common Files\Microsoft Shared\Repostry\repodbc.dll
and
C:\Program Files\Common Files\Microsoft Shared\Repostry\repbrui.dll
OR
open a Console Window and just punch it in
regsvr32.dll DLLToREGISTER.dll

Hth
Andi