DTS vs Job MAPI error! -
04-15-2004
, 01:05 PM
I have a DTS package that do some table copy and at the
end there is a
SQLMail task to send an email.
When I run the package from the Entreprise Manager it run
fine but when I
schedule the package to run in the server using a job that
calls the DTSRUN
utility here is what i get:
Executed as user: DOMAIN1\internet1. ...art:
DTSStep_DTSExecuteSQLTask_2
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun
OnStart:
DTSStep_DTSDataPumpTask_1 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_1;
999 Rows have been transformed or copied.; PercentComplete
= 0;
ProgressCount = 999 DTSRun OnFinish:
DTSStep_DTSDataPumpTask_1 DTSRun
OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 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 ... Process Exit Code 1. The
step
failed.
Does any body know what this error means.
I am able to send email using the XP_SENDMAIL and I can
make the server
send emails base in an alert condition.
What do I am missing. |