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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply