Hi,
I have a simple SQL Server DTS package with a Send Mail task. The package
executes successfully when I manually run the package. However, when I
access the package through a VB.NET app, it fails at "MapiLogonEx Failed due
to MAPI error 273: MAPI Logon failed". The package runs successfully without
the Send Mail task through app. Any ideas or help would be greatly
appreciated. This is the actual error




Step "DTSStep_DTSExecuteSQLTask_1" Succeeded



Step "DTSStep_DTSExecuteSQLTask_2" Succeeded



Step "DTSStep_DTSSendMailTask_1" Failed

Error: -2147220352

Source: Microsoft Data Transformation Services (DTS) Package

Description: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI
Logon failed.

any ideas?

Thanks

Have you had a read of this document. Maybe it will help

http://support.microsoft.com/default...;en-us;Q315886

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Chris" <Chris (AT) discussions (DOT) microsoft.com> wrote

Thanks for the info. I see there is a lot of trouble using the mapi client to
send email via sql server so I am looking into other alternatives.

"Allan Mitchell" wrote:

Yeah, MAPI sucks. Use SMTP.

Check out nice XSP from http://www.sqldev.net/


"Chris" <Chris (AT) discussions (DOT) microsoft.com> wrote