April 25, 2014 at 10:46 am
I am trying to run a proof of concept to prove I can send an email with the error message using the event handler OnError. I'm basically using the instructions here:
WhenI run the package the dataflow fails but I dont recieve an email but when I right click the send Mail task and left click Execute task I do get the email.
Why am I not getting the email when I execute the package?
April 25, 2014 at 11:12 am
Did you trace the package to make sure that you hit the Send Mail task? If so, then check any error messages (while debugging) for that task. Also, double-check your mail setup. Does it match your Outlook setup exactly (including ports, ssl,etc).?
April 25, 2014 at 11:17 am
I noticed that the OnError wasn't being called so I added a oledb source and selected a varchar column and then attempted to convert it to an integer to cause an error. After doing this it sent the email
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy