E-mail from DTS problems

[szlamany]

This isn't my DTS job - I'm helping a colleague...

Has anyone ever seen this error:

Error string: Error sending mail: The message store has reached its maximum size. To reduce the amount of data in this message store, select some items that you no longer need, permanently (shift + del) delete them. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 9100 Error Detail Recor... Process Exit Code 1. The step failed.

What message store are they talking about?

This was how the problem was explained to me:

Steve,



I am troubleshooting this issue – Cyril has it email him when the job completes, but it fails. He says that the emails come addressed from him. There is nothing wrong with his mailbox – I have not fond much online. Which store are they referring to?



I thought it might be the SMTP mail that was hanging up but they do not have SMTP installed o that server.



I asked Cyril to remove the email alert portion of the job to see if it completes then.



Any ideas?



CB

[RobDog888]

We've struggled with this same problem with mysterious MAPI 273 errors for no apparent reason and only when running from the job scheduler. We found the only way to fix it was to logon to the db server, delete the Send Mail Task and re-create it. Then it may suddenly return weeks later.

It appears that if you create the Send Mail Task when logged directly onto the db server, all is well. But as soon as you are on another pc and edit the DTS package containing this Send Mail Task, you get the 273 error. Perhaps not all the time, but I was able to make this failure happen. I didn't even touch the mail task, just added unrelated task to the package. And this caused the 273 error when running from the job scheduler.

Maybe this post would help or is relevant?

[kaffenils]

Could it be the message store for the Exchange server that the MAPI client used by DTS connects to?

Perhaps the problem is at the Exchange server, not the SQL Server. After all, SQL Server only uses the Outlook MAPI interfaces to send emails, so it is probably a message from MAPI.