SEND MAIL TASK - Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

SEND MAIL TASK - Error

Author

Topic

akhlaq768
Starting Member

12 Posts

Posted - 2009-07-23 : 11:52:00

I'm having trouble in getting my package to execute correctly; it fails on the SEND MAIL TASK procedure.

See below the Error message

Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "Failure sending mail.".
Task failed: Send Mail Task
Warning: 0x80019002 at Package Test: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package Test.dtsx" finished: Failure.
The program '[2820] Package Test.dtsx: DTS' has exited with code 0 (0x0).

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2009-07-23 : 11:59:19

Try each with "Use Windows Authentication" checked and unchecked. Sometimes it fails there.

Also try alias and IP on SMTP.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources