I have a number of DTS packages sat on an SQL 2000 server. Almost all of them have send mail tasks for notifications of success/failure. A number of the packages are failing on the send mail tasks with the error "Logon failed: MapiLogonEx failed due to MAPI error 273: MAPI Logon Failed"
I can't understand why some would work while others do not. Its consistent behavior per file, but seemingly random which files are not working.
Thanks for any help!