dbTalk Databases Forums  

DTS vs Job MAPI error!

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS vs Job MAPI error! in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
tuand2001@yahoo.com
 
Posts: n/a

Default 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.