Event Handler Refresh

I am current using Event Handlers in an SSIS package, but when adding a new EventHandler type eg. OnPreExecute, to an executable within the package, I am unable to see this new EventHandler defined in the hierarchical listing on the left hand combo box (named Executables).

Can't seem to find a Refresh option anywhere. I've only been able to see these newly created EventHandlers in the hierarchical listing by closing and re-opening the package.

Is this a 'feature' or am I missing a Refresh option somewhere.

Thanks.

Check the scope of the eventhandler you have created. Is it possible you are looking in the wrong place in the Package Explorer?

-Jamie

|||

Hi Jamie,

I have checked the scope and I am not looking in the incorrect place.

I wasn't not looking in Package Explorer though, but in the Executables drop-down box on the Event Handlers tab.

However the problem for me is replicated in Package Explorer also. Would you confirm that you are able to duplicate the problem ?

P R W.

|||

I don't seem to be able to repro your issue.

You said you were not looking at the Package Explorer, were you in the Event Handler diagram, then? If yes, and you did set the "Executables" drop down to the correct item, did you also set the "Event Handler" drop down (on the right) to, say"OnPreExecute" if that is the event? Since the default there is "OnError"

If you still get this, pls describe your SQL build version (RTM, SP1?) and your detailed steps. We'll see how we can help.

thanks

wenyang

|||

Hi P R W,

I'm not positive, but I think I saw this before I applied SQL Server 2005 SP1. Have you applied SP1?

Hope this helps,

Andy