DTS package send-mail task failure
-
Hi, I have created a simple DTS package to only send an an Email. It successfully works
when it is manually run. But when it is scheduled, that job fails.
I am already able to send e-mails from the scheduled jobs if they fail or succeed. When I try to send an e-mail inside DTS package which is scheduled job, it fails. I've tried to make it work with every possible user. DTS job owner , SQL server start-up user, the SQL agent start up account are the same and it is in SA role. Therfore I know the SQL agent proxy account
have a valid mail profile on the server and the DTS sendmail
uses this profile. I have executed the package by logging on to the machine using the same account. What can I do anymore?
The job history is as in the following:
DTSStep_DTSSendMailTask_1 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 Logon failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 9100 DTSRun OnFinish: DTSStep_DTSSendMailTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
Any help would be appreciated.
-
Are you sure you are using the correct mail profile? The SendMail task will only show local profiles.
You need to log into the server and edit the DTS package. Or if you know the profile name in advance, set the profile name using a dynamic properties task.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply