Hi


I have written a dts in SQL Server which uses the Send Mail task. I
would like to log the details of a failure, if the mail fails to be
delivered, ie if the email address is invalid.

The problem is that the Workflow On Failure event will only fire if the
mail fails to be sent, not if it fails to be delivered. As a result,
the mail will always send successfully, and the dts is unaware of any
failed deliveries.

Is there any way of checking for delivery success? I have a feeling
that this may not be a particularly easy thing to do, and will probably
involve interrogating the Exchange Server - any help on this would be
greatly appreciated.

Thanks


Dom

DTS AFAIK doesn't care or know about whether the recipient was valid or
not. It only cares about the "send" part.

Allan

"Boycey" <dom_boyce (AT) yahoo (DOT) co.uk> wrote

Just as I thought, and I think it will be too much work to get a
confirmation sent back, even if this is possible, using the MAPI
client. Especially since I have no experience of this at all.

Is it possible, though, to request that a delivery receipt is sent when
the email is delivered correctly? I can then use a manual process to
check, for each email sent, that it has been delivered correctly, and
update the SQL table as necessary.

I know that when sending an email from Outlook a delivery receipt can
be requested, but this is not the default. Does anybody know how to
force this when sending from the DTS?

Thanks again for your help,

Dom

You could set this up for the account under which you send mails in DTS.



"Boycey" <dom_boyce (AT) yahoo (DOT) co.uk> wrote

In message <#bsuqwhYFHA.3356 (AT) TK2MSFTNGP15 (DOT) phx.gbl>, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> writes
Receipts are a waste of time, as nobody (sensible) will send them
outside of their organisation. Please confirm my email address to any
spammers, maybe not.

I would manually check the mailbox for bounce messages, delivery
failures etc. If this is big job, then use a some proper mail server
software designed for bulk mailing, as this should be able to process
and manage your mail list, cleaning bad addresses etc.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

using a third party SMTP object, you could perform a synchronous send
method. As long as you do not use a relay server, or the recipient does
not front end their email server with a generic relay, you can determine
successful delivery to the server. read-reciept is by no means anything
you should look into...

Most 3rd party SMTP objects will not perform the required DNS MX Lookup for
the mail server end point. You would need one that supports this.

-Mike Gercevich

--
Message posted via http://www.sqlmonster.com

Thanks for all the input - been away for a week, hence my lack of
reply. I took the easy route out in the end and added a manual
verification to the process, whereby the user must check for any
delivery errors before confirming that the email has been sent. For
the amount of emails that will be sent out, it seems a lot of effort to
have an automated verification process.
Many thanks for your help though,

Dom