"Send Mail Task" Error.

I setup a "Send Mail Task" task and an SMTP connection objection. I ran the package and got this error:

>>>

SSIS package "Package.dtsx" starting.
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: 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.dtsx" finished: Failure.

>>>

Usually the SSIS error messages are too complicated for me to understand but this one doesn't say enough to be useful. Next, I purposely put in an invaid IP address (last octet = 3456 !) for the SMTP address, ran the package, and got the identical error message. I learned something.

What SSIS tools\logs\strategies can help me track down the problem?

TIA,

Barkingdog

I found the answer. The IS group changed the IP address of the email sevrer and I didn't know it. So...........why didn't SSIS error handling indicate it had trouble connecting to the server or was getting no response or.... something I could work with.

Hopefully, SSIS 2.0 will improve the clarity and quality of error reporting.

Barker

|||

If you have comments to make about future enhancements to SSIS then feed them back to MS via the Feedback Center: http://lab.msdn.microsoft.com/productfeedback/default.aspx

If you don't, you can hardly complain if your requirements are not fulfilled.

-Jamie

|||

Thanks for the Link. I am adding it to my favorites and will submit the request.

Barkingdog

|||

Excellent. I'm a big advocate of the Feedback Center.

-Jamie