SQL Server Developer Center >
SQL Server Forums
>
SQL Server Integration Services
>
Using "Column Mapping" Control in Custom Data Flow Component Editor
Using "Column Mapping" Control in Custom Data Flow Component Editor
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!
Answers
- 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.
- Marked As Answer byTodd McDermidMVP, ModeratorMonday, June 22, 2009 8:14 PM
- 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. I've posted directions on how to use the DtsMappingSurfaceControl (the control behind this capability) on my blog. Sample code is included.
- Marked As Answer byTodd McDermidMVP, ModeratorSunday, July 05, 2009 7:12 AM
All Replies
- 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. TYVM.
I would venture to say that most of the SSIS API is "undocumented" - but that's probably just mean.
- 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.
- Marked As Answer byTodd McDermidMVP, ModeratorMonday, June 22, 2009 8:14 PM
- 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. I've posted directions on how to use the DtsMappingSurfaceControl (the control behind this capability) on my blog. Sample code is included.
- Marked As Answer byTodd McDermidMVP, ModeratorSunday, July 05, 2009 7:12 AM
