IDTSComponentEvents' events? When are they fired?
Hi everyone,
I was wondering when events insideIDTSComponentEvents interface are called when you throw a SSIS package? I've got a private class which implementsIDTSEvents and along with that got another one that implements theIDTSComponentEvents. I see how neither of them are fired when I debug the code by using F11, and I don't know what is it for.
Let me know your comments or come back to me if you need further details on that.
Thanks in advance,
From my usage, tasks use IDTSComponentEvents. You do not generally implement this yourself, but implementations of it are passed to you in suitable methods such as the TaskHost.Execute method which you override when building a task. It allows you to fire events within the tasks's execute method.
IDTSEvents on the other hand I use when executing a package. I implement that in a class, and then handle the events through the IDTSEvents.OnEvent methods. Never had a problem setting breakpoints in my class to track progress during execution.
You may also want to implement IDTSLogging and use that alongside IDTSEvents when executing a package.