Does ssisUnit allows testing ssis packages with custom connection managers and other components?

[janis-veinbergs]

Hello @johnwelch

What if I use Kingswaysoft components that allows talking to web services easily. Can I somehow mock those connection managers and use ssisUnit to unit test those packages?

[johnwelch]

No, this isn't supported in ssisUnit.

The way that Connection Managers are implemented in SSIS makes mocking them very difficult. Tasks and Components can access the connection manager's inner object (the custom class) so you have to mock that. How possible that is depends on how the class was implemented, and how other objects interact with it. If it uses interfaces, and all interaction is via the interfaces, then it's doable. Not all connection managers are implemented in that way, though.