May 29, 2011 at 2:04 am
Good day All,
I created a new project, added a Execute SQL Task that fails. I went to the event handlers and added event handlers for "OnError" and "OnTaskFailed" to make sure one of the 2 runs.
I added a Send Mail Task in both event handlers that I created above that sends a mail when I execute the task manually.
I have checked the following properties:
a) Package - DisableEventHandlers = false
b) Execute SQL Task - DisableEventHandlers = false
c) OnError Event Handler - Disable = False
d) OnTaskFailed - Disable = False
I am not sure why the event handlers do not work, when I run the package the "Execute SQL Task" fails but the event handlers are both "white" (not green or red). I have tested this on 2 separate machines SQL 2005 and SQL 2008.
Can you please assist and tell me what I am doing wrong?
Thanks a stack.
Wikus
May 29, 2011 at 11:51 pm
If you set up the event handlers on the package level, do they work?
How do you fail the Execute SQL Task?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 30, 2011 at 12:53 am
Hi,
Nope, both the executable and package event handlers are not working. I just used a "Select substring()" query that is not correct.
May 31, 2011 at 11:57 pm
Do you run the entire package, or only the task by right-clicking it and selecting "Execute Task"?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply