May 7, 2002 at 9:30 am
Well once I got my DTS package to run as a job a part of my DTS package will not run in the job. It is the Mail portion. I have it setup to mail from my account on the machine to users. The problem is when I schedule the job and run it, it completes every step except the mail step. Here is the error I receive:
DTSRun OnError: DTSStep_DTSSendMailTask_2, 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: MA... Process Exit Code 1. The step failed.
Any suggestions will help.
Bobby
May 7, 2002 at 4:09 pm
The profile that is used by SQL Mail on the server needs to match the profile that is established in the mail task (default to currently logged on users profile).
Example: When one of the developers adds a mail task to a package I update the profile associated with that task to the profile that is associated with SQL Mail process on the server. The Mail task maintains the local (machine package is being created on) Mail profile as a default.
As a rule I have bailed on the gui mail task and have moved to a homegrown way of using xp_sendmail (insert into "notification" table and then process mail from table using xp_sendmail - no failures due to mail hangs and no profile associated in that task - one less hassle).
I'm not sure if I am making this clear so, if you need more information, please don't hesitate to scream.
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
May 13, 2002 at 6:37 am
Hi David,
I am having similar problems to the originator of this problem - do you know if there is anywhere where I could find a simple list of the steps required to configure my server.
I have Outlook & SQL Server 7 and I am not too sure what needs configuring in order for the sendmail step to complete successfully - the symptom is that the package runs in foreground but the sendmailstep fails when run in the background.
Thanks,
Mike.
May 13, 2002 at 10:46 am
Mike,
Check out the MS Articles Q263556 and Q315886. These give a good overview of what is required to set up SQL Mail and then common problems associated with it.
My response back was also indicating that it is wise to avoid using SQL Mail in critical paths of jobs as when it fails then the job or DTS package will fail as well. Just a word of caution.
If you have any specific questions following review of the articles, please post and I will do what I can to help.
Until then...
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply