After installed SQL Server 2005 Management Studio, my SQL2000 Enterprise Manager encountered an error while modifying the email notification component in DTS packages.
The error message is like this:
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: Cannot load MAPI interface layer for DTS. Please make sure that semmap90.dll is installed.
Execution cannot continue as the language dependent resources file ...\1033\semmap90.dll could not be loaded.
The error came up because after you installed SQL2005 management studio, the windows registry has updated to newer versions.
The fix is quite simple. If you installed the SQL2000 Desktop Engine in default location then it can be done in this folder:
c:\Program Files\Microsoft SQL Server\80\Tools\BINN\Resources\1033\
(You can copy and paste this link into your PC's Start->Run box and hit "Enter".)
In this folder, copy the semmap.rll and paste in the same folder, then rename it to semmap90.rll. That's all you need to do.
Note: this is RLL file, not DLL.
Showing posts with label DTS. Show all posts
Showing posts with label DTS. Show all posts
Monday, September 8, 2008
Thursday, August 28, 2008
"semmap90.dll is installed" for SQL2000 DTS Mail Object
The environment at my work has both SQL server 2000 and 2005.
After I upgraded the Enterprise Manager of SQL2000 to Management Studio from SQL2005, I can no longer view or modify the MailObjects in SQL2000 DTS packages.
(DTS stands for Data transformation system)
The error is "Please make sure the semmap90.dll is installed."
I installed Enterprise Manager again and tried to open the DTS package MailObject, it gave me the same error message.
Based on a document from microsoft Technet, the solutiion is:
On the computer where you installed the desktop engine to run management studio, go to
..\Microsoft SQL Server\80\Tools\binn\
Then rename semmap.dll to semmap90.dll
Or you can make a copy of the dll and renamed the new one as semmap90.dll. In this case, you have two dlls so both Enterprise Manager and Management Studio can work.
No need to reboot or restart Management Studio, it immediately fixed the error.
After I upgraded the Enterprise Manager of SQL2000 to Management Studio from SQL2005, I can no longer view or modify the MailObjects in SQL2000 DTS packages.
(DTS stands for Data transformation system)
The error is "Please make sure the semmap90.dll is installed."
I installed Enterprise Manager again and tried to open the DTS package MailObject, it gave me the same error message.
Based on a document from microsoft Technet, the solutiion is:
On the computer where you installed the desktop engine to run management studio, go to
..\Microsoft SQL Server\80\Tools\binn\
Then rename semmap.dll to semmap90.dll
Or you can make a copy of the dll and renamed the new one as semmap90.dll. In this case, you have two dlls so both Enterprise Manager and Management Studio can work.
No need to reboot or restart Management Studio, it immediately fixed the error.
Subscribe to:
Posts (Atom)
