SQL2005 : Database Mail from DTS Package

Posted on 2008-11-11
Last Modified: 2013-11-30
I need to have the e-mail alert sending out from DTS Package from SQL2005 Server; but, found can not select e-mail profile from DTS package - there is no e-mail profile can be selected from the selection list.

I have checked the following:
1. From Server Surface Area configurateion - the Database Mail store procedure is enabled;

2. Try to send Test E-mail from Database Mail -
   a. the mail is in the queue with "unsent" status
        SELECT * FROM msdb.dbo.sysmail_allitems

   b. and, it can not be found from the log
        SELECT * FROM msdb.dbo.sysmail_log

Please advise ...

Question by:dannytsao
    LVL 31

    Expert Comment

    by:James Murrell
    Go on the SQL Server properties under Enterprise Manager, the Server Settings tab, SQL Mail section there and hit Change in case there is nothing there. Pay attention to the text:
    "Enter a valid MAPI profile name. This profile name must be configured and tested for the startup user account of the MSSQLServer service." When trying to put an invalid account there, it will give you more valuable information:

    "Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client."

    i think it won't work with an HTTP account.

    Author Comment

    Enterprise Manger ???
    We are running with SQL2005; I guess you are referreing with SSMS ? If it is, SQL Mail  is disabled in SQL2005, and replaced by database mail; shoud I enable it?
    LVL 31

    Expert Comment

    by:James Murrell
    whoops sorry, yes enable

    Author Comment

    I hit waring message when I tried to enable SQL Mail :
    "SQL Mail does not work with 64bit versioin of SQL Server"... ; can not enalbe SQL Mail.
    LVL 9

    Expert Comment

    did you try to see helpful links, hope these will help
    -- cheers

    vbscript to test ability to send email using SMTP server of your choice

    user apparently experienced similar trouble with database mail

    Troubleshooting Database Mail MSDN article
    LVL 31

    Accepted Solution

    just seen this

    Service Pack 1 fixed this for DB Mail. I was just looking at which says this.

     See for SQL Mail to DB Mail conversion, this is what you want to use in SQL 2005. General how-to setup database mail:

    Author Comment

    Dear All,

    I had our Coopreate IT support to help it out. The e-mail in the DTS Package, migrated from SQL2000, is referred to Outlook exchange e-mail account. It won't call database mail, unless change the DTS package.

    At the end, I need to creat an outlook profile so that it can be selected from the DTS e-mail drop-down selection.  So, it solved this part of the issue.

    But, on the other hand, the testing e-mail from database mail still can not fire up; unless I dobule click "databasemail90.exe".

    I have gone thru a lot of posts but still can not slove this issue.


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now