BUG: DTS Send Mail Task Does Not Display Correct Mail Profile Name in DTS Designer (288438)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q288438
BUG #: 352129 (SHILOH_BUGS)

SYMPTOMS

When you use the Data Transformation Services (DTS) Designer to view the properties of a Send Mail task, the mail profile name that is listed is the default mail profile of the client from which you are launching Enterprise Manager, and may not be the mail profile name saved with the Send Mail task.

CAUSE

The DTS Designer lists local mail profiles, not the mail profiles on the server.

WORKAROUND

To view the mail profile name saved with the DTS Send Mail task, use the Disconnected Edit feature of the DTS Designer. Expand the Tasks collection and select Send Mail Task; the mail profile name is stored in Profile Property Name.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.

MORE INFORMATION

If the client has a local mail profile with the same name as the profile that is saved with the Send Mail task, the Send Mail task properties show the correct profile name. However, this mail profile is a local profile on the client you are using to edit the package, and not a mail profile on the SQL Server server you are connected to in Enterprise Manager.

When designing a package from a client, if you need to specify a mail profile on the server, add the DTS Send Mail task and then use the Disconnected Edit feature to change the name of the mail profile.

If the client has a local mail profile, and no profile with the same name exists on the server, when the package is run as a scheduled job or run from SQL Server Enterprise Manager on the server, it may fail and the following error occurs:
Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbBug kbpending KB288438
©2003 Microsoft Corporation. All rights reserved.