We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Scheduling DTS Package execution error

yilmazonur
yilmazonur asked
on
Medium Priority
1,454 Views
Last Modified: 2013-11-30
I have a DTS Package.The package sends mail.

When I execute the package interactively, it sends the mail with out error. However, when the package is scheduled through SQLAgent, I get the error.

The problem seems to be when a DTS package is executed from the Scheduler. The use is getting a MAPI 273 error. See below:
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

Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Yes. Please check your security accounts
- Edward
Just a followup...

I had this same problem on a SQL Server here.  After exhausting every possibility and checking every configuration, on a hunch I went into the DTS SendMail task, and just re-selected the same profile (making sure to actually click it in the drop-down, even though it was the only one on the list).  This solved the problem, despite the fact that I didn't *really* change anything.

Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.