DTS Mail task breaks after SQL 2005 uninstall/install

When I try to add a Mail Task in my SQL 2000 DTS, I get a message "Please make sure semmap90.dll is installed. When I try to register that dll using regsrv32.exe, it says the entry point is not found.

Any ideas on how to get my e-mail task back

Answer this question

DTS Mail task breaks after SQL 2005 uninstall/install

Kmad
Here's a quick summary of the files and versions I have. Everything still works fine.
I'm running SQL Server 2000, SP4.

This directory needs two DLL's:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
semmap.dll - (version 2000.80.2039.0)
semmap90.dll - (version 2000.80.194.0)

This directory needs two RLL's (I made a copy of semmap.rll and named it semmap90.rll):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
semmap.rll - (version 2000.80.194.0)
semmap90.rll - (version 2000.80.194.0)

- Dana
Dave Breuer
I've been looking for that answer for 3 days now - thank you so much DanaDBA!

--Wil
murr
I should point out that I've installed, uninstalled, and then reinstalled SQL 2005 on this machine.
Pogaru
DTS is now called SQL Server Integration Services. Could you repost this question in the SSIS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=80&SiteID=1)
weejay
Go to the 80 directory that's installed with SQL Server 2000 -
(\Microsoft SQL Server\80\Tools\Binn)

Rename the semmap.dll file to semmap90.dll
Mohamed Hussein

Ok - I have this working on 2000 and 2005, but I went through some hurdles to get here.

When I installed the Microsoft SQL Server 2000 DTS Designer Components, I noticed the \80\Tools\Binn directory had both dll files - semmap.dll and semmap90.dll (both were not there originally). SQL Server 2000 was throwing tons of errors when loading enterprise manager.

I uninstalled the DTS designer components, still had errors. I uninstalled and then reinstalled SQL Server 2000. It still would not work until I applied SP4.

SQL Server 2000 is now working again - now for the DTS mail issue

When trying to open the send mail task in 2000, I got an error regarding a missing file - semmap90.rll (RLL) in this directory. -
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
This directory had the semmap.rll file, so I made a copy of it and then renamed it to semmap90.rll. Now this resources folder has semmap90.rll and semmap.rll. Both are the same exact files, just different names.

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
- There should be two dll files in here (semmap.dll and semmap90.dll). If you do not rename the original semmap.dll to semmap90.dll, prior to installing the Microsoft SQL Server 2000 DTS Designer Components, you will only have one of the files (was able to verify this on another system - 2000 SP4, 2005 and the DTS designer components were all installed).

I got this working in a pretty funky way, but it's working. Not sure at this point what else I may have broken.

Good luck. Email me if you have any questions.

drivkind@gmail.com

- Dana Rivkind
RyanMcClellan
Thanks! Note you want to Copy (not rename) but this did the trick!
Cridal69
I'm messing around with this more and here's what I've found now -

SQL Server 2005 will not open the DTS package unless you install - Microsoft SQL Server 2000 DTS Designer Components

Once I installed this package, I broke SQL Server 2000 completely. Now I can open the DTS package in 2005, but I'm still getting some buggy issues. And, now when I reinstall SQL Server 2000, it will not work.

Make sure you make these changes on a test server. I'll post an update after I get re-configured and test some more.
DTS Mail task breaks after SQL 2005 uninstall/install

Answer this question