SQL2005 : Database Mail from DTS Package

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 ...

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

James MurrellProduct SpecialistCommented:
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.
dannytsaoAuthor Commented:
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?
James MurrellProduct SpecialistCommented:
whoops sorry, yes enable
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

dannytsaoAuthor Commented:
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.
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
James MurrellProduct SpecialistCommented:
just seen this http://sql-server-performance.com/Community/forums/p/22045/126977.aspx#126977

Service Pack 1 fixed this for DB Mail. I was just looking at http://blogs.msdn.com/sanchan/archive/2006/04/23/581639.aspx which says this.

 See http://msdn2.microsoft.com/en-us/library/ms187891.aspx for SQL Mail to DB Mail conversion, this is what you want to use in SQL 2005. General how-to setup database mail: http://msdn2.microsoft.com/en-us/library/ms188298.aspx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dannytsaoAuthor Commented:
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.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.