I have a simple job that is giving me errors.

Step (1) is selecting records and outputting the data to a .txt file.

Step (2) is executing a SendMail DTS package that is supposed to email the .txt file to (3) known/working email addresses.

My problem is that step 1 executes fine. Step 2 keeps giving me this error message below. Can anyone help me figure out how to fix this, or simply how to successfully email a .txt file within a job?

Thanks,
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.

I got an error after sending my email, I thought it did not post. This exact email is posted below, please disregard this one.

----- ChelleV wrote: -----

I have a simple job that is giving me errors.

Step (1) is selecting records and outputting the data to a .txt file.

Step (2) is executing a SendMail DTS package that is supposed to email the .txt file to (3) known/working email addresses.

My problem is that step 1 executes fine. Step 2 keeps giving me this error message below. Can anyone help me figure out how to fix this, or simply how to successfully email a .txt file within a job?

Thanks,
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.

In article <34179AED-347E-4E87-BB69-1C8386EB3F27 (AT) microsoft (DOT) com>, ChelleV
<anonymous (AT) discussions (DOT) microsoft.com> writes
My problem is that step 1 executes fine. Step 2 keeps giving me this
error message below. Can anyone help me figure out how to fix this, or
simply how to successfully email a .txt file within a job?

Thanks,
ChelleV

<snip>

If this only happens when scheduled then check the name of the MAPI
profile, available to the SQL Server Agent service account. Make sure
your job executes under that account as well. MAPI profiles are local to
the machine and also account specific. Does SQL Mail work? Does SQL
Server run under the same service account as your job?

Have a look at this KB as whilst it does not cover this specific issue
it does explain similar issues as well as the conceptual differences
around scheduled DTS packages-

http://support.microsoft.com/?kbid=269074

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

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

Has the SQL mail configured on the server side? You may want to chek to see which email profile is being used in the DTS. Support arcticle: http://support.microsoft.com/default...b;en-us;288438