Monday, September 8, 2008

Can't edit DTS package email notifications

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.

Step by Step Installing Visual Studio 2008

Having heard so many good words about Visual Studio 2008 (VS2008), I decided to give it a try on my develop machine. Overall, it is a pleasant experience and everything worked just fine and smooth.

In the morning, the first thing after checking emails, I backed up my PC. It took about 25 minutes to create a backup of my current documents and etc.

Next, I put the VS2008 (standard version) install DVD into the DVD-rom. It was a colorful DVD with laser marks “genuine” and “made in Puerto Rico”. Well, “Genuine” matters but “Made in Puerto Rico” doesn’t matter.

First, the process began to copy files to local hard drive. You shall be patient not to interrupt it. After a screen to enter the product key, five sets of five character keys, the installation wizard showed a screen of components to install. By default, everything on the list was selected. But I un-checked the SQL2005 express, which is an optional item, because I have this component already.

Then the installation wizard began to copy files from DVD to my PC. It was a long list of components, from Microsoft .NET Framework 3.5, Microsoft Document Explorer 2008, Microsoft Visual Studio Web Authoring Component, Microsoft Visual Studio 2008, Microsoft SQL server Compact 3.5 (and design tools), several SDKs for Visual Studio 2008 and a Microsoft SQL Publishing Wizard.

After it installed the third component “Microsoft Visual Studio 2008”, a window popped up saying you can install MSDN documentation separately and etc. Then you have to reboot your PC.

This is the end. The total installation process took about 25 minutes on my Dual-Core P4 3.5GHz PC.

After the PC rebooted, you can open Visual Studio 2008 from Programs menu. For the first time, it will ask you what your primary development is; you can choose VB, C# or Web. I chose web because my work mostly involves ASP.NET SQL server and other web pages.

On the start page, it didn’t show any links (RSS feeds) about ASP.NET and wanted me to check the “Tools->Options->Environment” settings. Ok, I didn’t see the environment at first. The trick is you have to check the “Show all settings” checkbox at the bottom of left column. Then all settings appeared.

Now, it’s time to sail in VS2008.