February 12, 2008 at 10:59 pm
Hi all,
I have used an OnError event handler in my package where it logs when an error has occurred. However, if the package stops executing midway or the execution is stopped for some reason, how can get to know the status? can i use any event handlers for the same?
February 13, 2008 at 4:21 am
Hi,
Have you used the OnError event under the Configure SSIS Logging dialog or the OnError even under the Event Handlers tab in the designer. On the later you can do some thing to notify or flag the error.
Daniel
February 13, 2008 at 8:58 pm
I have used the OnError event handler and it is working fine. but when i stop the execution, no error is thrown so the event handler will not be called. can i use OnQueryCancel event handler?
February 14, 2008 at 8:24 am
Looks like you are going to have to test them to see which event it appropriate. I would look at OnExecStatusChanged first. There are also package system variables called Cancel And CancelEvent which might be worth looking at.
February 18, 2008 at 11:01 pm
tanmayi_mukundan (2/12/2008)
Hi all,I have used an OnError event handler in my package where it logs when an error has occurred. However, if the package stops executing midway or the execution is stopped for some reason, how can get to know the status? can i use any event handlers for the same?
I have also been asked to do the same thing. Basically what my boss wants is kindda "progress meter" while the whole process is taking place as he don't want to sit there watching the package the whole day. What if it takes more than an hour(or more) to finish executing? That's the reason. I tried thinking hard for this, but i guess SSIS just would not be able to give out a progress meter. Or would it be posibble? Anyone?
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply