Microsoft KB Archive/288438

= BUG: DTS Send Mail Task Does Not Display Correct Mail Profile Name in DTS Designer =

Article ID: 288438

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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.

Additional query words: dts mail task

Keywords: kbbug kbpending KB288438

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.