December 27, 2004 at 1:58 pm
I am receiving the following error for a scheduled job.
DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 9100 Error Detail Records: Error: -2147220352 (80040480); Provider Error: 0 (0) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Lo... Process Exit Code 1. The step failed.
Looks like the configuration of the mail profile is incorrect, but when I test the mail profile under SQL server agent, it shows "Successfully started ( and stopped) a mail session with this profile." In addition, I was able to received a notification email from the server regarding job failure concerning the above error.
Any idea?
December 27, 2004 at 2:46 pm
Amy,
Using the mail task in DTS can be somewhat odd in that if you add the task while developing from your PC then it will use your Outlook mail profile for the task. The best way to do this is to connect to the server via Termial Services and add these tasks so that you get the Outlook profile that SQL Server is using.
Better yet is to use a standard SQL Task and use xp_sendmail (although I'm sure some would disagree with me).
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 29, 2004 at 1:48 pm
Thanks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply