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
"Send Mail Task" Error.
Mirgle
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
MarioMor
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
hrh
Excellent. I'm a big advocate of the Feedback Center.
-Jamie
Adam Friedman
Thanks for the Link. I am adding it to my favorites and will submit the request.
Barkingdog