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

johnwelch / ssisUnit

Microsoft Reciprocal License

28 stars 6 forks source link

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

Open janis-veinbergs opened 5 years ago

janis-veinbergs commented 5 years ago

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 commented 5 years ago

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.