I have a job, with 2 simple steps. Step 1 is a select statement, which outputs data to a .txt file, this step works fine.

The second step, I have a DTS SendMail package. I'm sending it to a known working email address, with the .txt attachment. I keep getting the error message below.

I appreciate any ideas on how I can successfully email this .txt file. Thank you!
-ChelleV

Executed as user: WELLMARK\WellmarSQL. DTSRun:
Loading... DTSRun: Executing... DTSRun OnStart:
DTSStep_DTSSendMailTask_1 DTSRun OnError:
DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480)
Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp Help context: 9100 Error Detail Records:
Error: -2147220352 (80040480); Provider Error: 0 (0)
Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp Help context: 9100
DTSRun OnFinish: DTSStep_DTSSendMailTask_1
DTSRun: Package execution complete. Process Exit Code 1. The step failed.

See you other thread "SendMail DTS Error" ...

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org