Friday, March 23, 2012

Name of the column mapping UI control?

I am developing a transformation component and I'd like the gui to feature one of the mapping controls that are used for mapping input columns to, for example, SQL Server database columns in the OLE Database Destintation component, among others. I cannot for the life of me discover what the control is called or even whether it is available for general use. Can anyone help me out? Sorry if this is OT but it seemed like the people here would be the most likely to know immediatelly what I was on about.

Thanks
Charlie.

I am trying to do a similar thing and the tool you described would be useful for me too. Did you have any luck finding it?

Your help will be greatly appreciated,

Savita

|||No not at all. I ended up using a tree view to show the mapping and two list boxes, one for each side of the mapping. It doesn't look *great* but it works and besides, the mapping component I was talking about is pretty hellish to actually use if the mapping involves lots of lines that cross over. Even SSIS has two views on the same thing to make it look fancy and be clear.

Charlie
|||As far as I know, and I have asked and looked, that control and much of the data flow UI controls are both undocumented and/or inaccessible. In fact I don't think the UI is managed at all, so would be rather nasty to try and use even if you could find and access it.

No comments:

Post a Comment