dts and mapi login failure

[ehague]

I have several dts packages that run just fine through a third party scheduler. I then put a mail task on them to tell me if the package succeeded or failed. Every time the scheduler gets to the mail task it fails and logs a mapi login failure error. When I execute the dts package on my local box it sends the email with no problems. is it a problem with the robot login or is it associated to the profile? any help would be greatly appreciated.

Elizabeth

 

[RickCole]

When you run the package from your local box it runs under your user account credentials. When you run it from the scheduler it runs under the SQL Server Agent Account. Have a look at the following link, which goes into a bit more detail on this problem.

http://www.tek-tips.com/faqs.cfm?spid=183&sfid=280&CFID=37028510&CFTOKEN=48131709

Rick.