Article ID: 261133 - View products that this article applies to.
This article was previously published under Q261133
BUG #: 57661 (SQLBUG_70)
When you create a package that uses SQL Server's Data Transformation Services (DTS) Send Mail task to send messages, a sender's mailbox fills up steadily because DTS reports error messages such as:
However, if you review the sender's Microsoft Outlook SentItem folder and check the mailbox size, the mailbox size is near 0 KB, and nothing is in the sender's mailbox from Outlook's point of view.
Cannot execute package because mailbox is full.
If you check the sender's mailbox size from the Exchange Server Administrative console, the correct size of the mailbox displays. However, you cannot see the messages that fill up the mailbox because those messages are hidden from Outlook and the Exchange Server.
The Outlook and Exchange clients cannot view any items under the root directory of the Exchange Server Information Store. After DTS Send Mail sends out the message, DTS keeps the message in the root folder of the sender's (source) mailbox on the Exchange Server. Therefore, the sender's Outlook client cannot view or delete these messages.
Use the Microsoft Exchange utility, MDB Viewer, to view the hidden e-mail messages that fill up the mailbox. You can also use MDB Viewer to delete those messages.
Follow these steps to check the root folder of the mailbox that is configured for use by DTS Send Mail:
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
274799For more information, contact your primary support provider.
(http://support.microsoft.com/kb/274799/ )INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
If you use the Send Mail task in the DTS GUI designer, mail is not saved in the Sent Items folder by default. The DTS GUI does not have an option to change this behavior in the current version. However, you can change the behavior by using Microsoft Visual Basic code:
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/308758/EN-US/ )FIX: SQL Agent Mail May Cause E-mail to Be Written to Root Directory of Source Mailbox