Tuesday, March 20, 2012

Connection manager validation within UI

Hi all,

I need to validate a custom connection manager within its custom user interface, like the FlatFileConnectionManager does it, by showing errors and warnings at the bottom of the window.

How can I do that since SSIS provides only a ConnectionManager object with the IDtsConnectionManagerUI::Initialize method, and this object doesn't contain any Validate method?

Note that for a custom data flow component, SSIS provides a ComponentMetaData object which supports a Validate method.

Thanks.

Pascal

The UI class is just the stub that allows SSIS to find your UI implementation. You need to add a form that displays controls for setting properties and such like. Within that form you can call the Validate method on your connection class, capture the messages and display them as you wish. There is a connection manager sample with UI in the updated samples available from the MS site, Downloads area. For more samples, look at a task, as this follows exactly the same pattern as for a connection. Components are quite a bit different.

|||I can't call the Validate method of my custom connection manager because SSIS doesn't give me my object but a ConnectionManager which is not a ConnectionManagerBase type...

No comments:

Post a Comment