Here’s what I’m doing with the data flow.
Load a package through get-ISPackage, then grab the executable.innerObject of a data flow task. Then you can create a wrapper through marshalling. I’m not exactly sure what this is doing, but it works and gives
me access to the innards of the data flow.
Once I have this, I can loop through the components of the DFL task.
Send me an offline message to [email removed] and I will send you an invite to my private POSH repository so you can check out my work on a testing suite for SSIS packages.
I’m completely open to feedback on how I’m doing this. I’d like to release this test suite to the community as something they could use to test their packages before release, so they know the packages will be
good to go in production!
Maybe we should skype some time to talk about your goals for SQLPSX and see where I can best contribute!