What is SSIS order of data transformation component method calls

Posted by Ron Ruble on Stack Overflow See other posts from Stack Overflow or by Ron Ruble
Published on 2010-03-18T20:35:11Z Indexed on 2010/03/23 6:53 UTC
Read the original article Hit count: 282

I am working on a custom data transformation component. I'm using NUnit and NMock2 to test as I code. Testing and getting the custom UI and other features right is a huge pain, in part because I can't find any documentation about the order in which SSIS invokes methods on the component at design time as well as runtime.

I can correct the issues readily enough, but it's tedious and time consuming to unregister the old version, register the new version, fire up the test ssis package, try to display the UI, get an obscure error message, backtrace it, modify the component and continue.

One of the big issues involves the UI component needing access to the componentmetadata and buffermanager properties of the component at design time, and what I need to provide for to support properties that won't be initialized until after the user enters them in the UI.

I can work through it; but if someone knows of some docs or tips that would speed me up, I'd greatly appreciate it. The samples I've found havn't been much use; they seem to be directed to showing off cool stuff (Twitter, weather.com) rather than actual work.

Thanks in advance.

© Stack Overflow or respective owner

Related posts about ssis

Related posts about ssis-data-tranformations