email task fail in DTS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

email task fail in DTS

hi, I have a dts package on sql server 2000 server, that
sends a mail to the users upon successfull completion of the job.Yday I modified the emial task by removing a userid from the list as he is no more in service. when I check the log file of package today it says only the last task(DTS mail task) has been failed.when I am trying to execute the last email task I am getting the following the error.
‘error source: microsoft data transformation services
(DTS) package.
Error description: logonfailed: MapilogonEx failed due to
MAPI error 273: MAPI logon failed.’ Can any pls help…
Thanks!
"He laughs best who laughs last"
May check this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886 is any help. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks satya.. I want to explain where I was wrong.
When I have done some changes and save it to my DTS,I did it through instance of the server and so there was a problem. since that DTS was originally created in the main server, so when ever we do some changes to that task we have to login through that account and proceed for changes.This is what I understand.Thanks Thanks!
"He laughs best who laughs last"
Yes, you’re right and make sure the defined account has required privileges to carry on additional mailing tasks. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>