SQL2005 : Database Mail from DTS Package
Posted on 2008-11-11
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 ...