Using "Column Mapping" Control in Custom Data Flow Component Editor

Question

 

Does anyone know how I can get at (if possible) the "standard" column mapping control that's used extensively in SSIS Data Flow components?

 

This one: http://picasaweb.google.com/toddmcdermid/TechSupportPics#5261145460828949234

Any ideas are appreciated!

Answer 1

Search for DataFlowUsageTypePage class (part of Microsoft.DataTransformationServices.Design assembly). This is the tab page hosting the column mapping control.

Get ready to spend a lot of time, browsing the SSIS framework with Reflector. This functionality is undocumented.

Answer 2

TYVM.

 

I would venture to say that most of the SSIS API is "undocumented" - but that's probably just mean.

 

Answer 3

I have been looking for this for a long time as well. Pointing me in the direction of the Microsoft.DataTransformationServices.Design assembly helped me a lot, although I could not find the mentioned DataFlowUsageTypePage class.

However, if you add Microsoft.DataTransformationServices.Design to your toolbox in Visual Studio, one of the added controls is the DtsMappingSurfaceControl.

This control has a number of methods to initialize the left and right table, using a ColumnInfo array.

The number of properties and methods on this control are limited, and pretty much self-explanatory.

A large number of other standard SSIS UI elements are also at your disposal using this method.

Answer 4

Thanks for the direction KimYda!

I've deciphered the object model and have made the UI work for me - even though there's way more work involved than I think there should be.  (But that may be due to me not taking advantage of things I don't know that are there.)

The code to use this capability will soon be published on CodePlex as part of the Kimball SCD transformation, in v1.5.  It's not ready yet - but the code will be there shortly.

---

Answer 5

I've posted directions on how to use the DtsMappingSurfaceControl (the control behind this capability) on my blog.  Sample code is included.

---