Hi everyone,
I was wondering when events inside IDTSComponentEvents interface are called when you throw a SSIS package? I've got a private class which implements IDTSEvents and along with that got another one that implements the IDTSComponentEvents. 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,
Any ideas?|||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.
|||Thanks Darren for your comments.
No comments:
Post a Comment