(dts newbie)
I keep getting the following error when I run my DTS package. "Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed." The data comes over fine, it's the confirmation email that doesn't work. Thanks in advance.

Todd

Do you have a mail client setup for SQLSERVERAGENT. You must setup a mail client such as Outlook 2000 and run the SQLServer and SQL SERVERAGENT account using a domain account. The account used must have the proper permissions to execute DTS. Also, in order for the account to work it must belong to the msdb database.

Keep in mind that if you have a mail client setup and your are running from your workstation, it uses the credentials from your local outlook profile. run it from the server and see what happens. Either check all that apply.