<p align=left><font face=Arial size=2></font> </p> <p>Does anyone know how I can get at (if possible) the &quot;standard&quot; column mapping control that's used extensively in SSIS Data Flow components?</p> <p> </p> <p align=left>This one: <a title="http://picasaweb.google.com/toddmcdermid/TechSupportPics#5261145460828949234" href="http://picasaweb.google.com/toddmcdermid/TechSupportPics#5261145460828949234">http://picasaweb.google.com/toddmcdermid/TechSupportPics#5261145460828949234</a></p> <p>Any ideas are appreciated!</p>© 2009 Microsoft Corporation. All rights reserved.Sun, 05 Jul 2009 07:12:13 Z7eb57ef2-9675-4959-a4dd-f5d0dd7852c7http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7eb57ef2-9675-4959-a4dd-f5d0dd7852c7#7eb57ef2-9675-4959-a4dd-f5d0dd7852c7http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7eb57ef2-9675-4959-a4dd-f5d0dd7852c7#7eb57ef2-9675-4959-a4dd-f5d0dd7852c7Todd McDermidhttp://social.msdn.microsoft.com/Profile/en-US/?user=Todd%20McDermid<p align=left><font face=Arial size=2></font> </p> <p>Does anyone know how I can get at (if possible) the &quot;standard&quot; column mapping control that's used extensively in SSIS Data Flow components?</p> <p> </p> <p align=left>This one: <a title="http://picasaweb.google.com/toddmcdermid/TechSupportPics#5261145460828949234" href="http://picasaweb.google.com/toddmcdermid/TechSupportPics#5261145460828949234">http://picasaweb.google.com/toddmcdermid/TechSupportPics#5261145460828949234</a></p> <p>Any ideas are appreciated!</p>Sat, 25 Oct 2008 17:33:05 Z2008-10-25T21:40:09Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7eb57ef2-9675-4959-a4dd-f5d0dd7852c7#5db4991d-2ae2-4984-9731-596b89c1bb6chttp://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7eb57ef2-9675-4959-a4dd-f5d0dd7852c7#5db4991d-2ae2-4984-9731-596b89c1bb6cCozyRochttp://social.msdn.microsoft.com/Profile/en-US/?user=CozyRoc<font size=2><span style="font-family:Arial">Search for <span style="font-weight:bold">DataFlowUsageTypePage</span> class (part of </span></font><span style="font-weight:bold">Microsoft.DataTransformationServices.Design</span> assembly). This is the tab page hosting the column mapping control.<br><br>Get ready to spend a lot of time, browsing the SSIS framework with Reflector. This functionality is undocumented.<br>Sat, 25 Oct 2008 20:27:51 Z2008-10-25T21:40:09Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7eb57ef2-9675-4959-a4dd-f5d0dd7852c7#ef2cae8a-95e4-4ab5-9a30-4c4dddd11d2dhttp://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7eb57ef2-9675-4959-a4dd-f5d0dd7852c7#ef2cae8a-95e4-4ab5-9a30-4c4dddd11d2dTodd McDermidhttp://social.msdn.microsoft.com/Profile/en-US/?user=Todd%20McDermid<p>TYVM.</p> <p align=left> </p> <p align=left>I would venture to say that most of the SSIS API is &quot;undocumented&quot; - but that's probably just mean. <img src="http://forums.microsoft.com/msdn/WebResource.axd?d=NySzF1eivP_rMoc50GQJzcvS4MHMOEKwYrCIgDtzuzlw7GsNki3H_INlfYaLgkxFLZDXE86Ufh419QUP957dw4aRCsggZAWbaWGtvyG178k1&amp;t=633337194230757564"></p> <p align=left><font face=Arial size=2></font> </p>Sat, 25 Oct 2008 21:40:54 Z2008-10-25T21:40:54Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7eb57ef2-9675-4959-a4dd-f5d0dd7852c7#f10a7f45-4c44-46cd-acdf-be40eb97b744http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7eb57ef2-9675-4959-a4dd-f5d0dd7852c7#f10a7f45-4c44-46cd-acdf-be40eb97b744KimYdahttp://social.msdn.microsoft.com/Profile/en-US/?user=KimYda<div>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.</div> <div><br/></div> However, if you add Microsoft.DataTransformationServices.Design to your toolbox in Visual Studio, one of the added controls is the DtsMappingSurfaceControl. <div><br/></div> <div>This control has a number of methods to initialize the left and right table, using a ColumnInfo array.</div> <div><br/></div> <div>The number of properties and methods on this control are limited, and pretty much self-explanatory.</div> <div><br/></div> <div>A large number of other standard SSIS UI elements are also at your disposal using this method.</div>Fri, 29 May 2009 15:03:09 Z2009-05-29T15:03:09Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7eb57ef2-9675-4959-a4dd-f5d0dd7852c7#e7d94138-04ef-46ba-a9cd-6280458adb2fhttp://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7eb57ef2-9675-4959-a4dd-f5d0dd7852c7#e7d94138-04ef-46ba-a9cd-6280458adb2fTodd McDermidhttp://social.msdn.microsoft.com/Profile/en-US/?user=Todd%20McDermidThanks for the direction KimYda!<br/><br/>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.)<br/><br/>The code to use this capability will soon be published on CodePlex as part of the <a href="http://kimballscd.codeplex.com/">Kimball SCD</a> transformation, in v1.5.  It's not ready yet - but the code will be there shortly.<hr class="sig"><a href="http://feeds.feedburner.com/~r/ToddMcdermidsBlog/~6/3"><img src="http://feeds.feedburner.com/ToddMcdermidsBlog.3.gif" alt="Todd McDermid's Blog" style="border:0"></a>Mon, 22 Jun 2009 20:13:44 Z2009-06-22T20:13:44Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7eb57ef2-9675-4959-a4dd-f5d0dd7852c7#1e099505-f313-4baa-8c24-1de092c4d787http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7eb57ef2-9675-4959-a4dd-f5d0dd7852c7#1e099505-f313-4baa-8c24-1de092c4d787Todd McDermidhttp://social.msdn.microsoft.com/Profile/en-US/?user=Todd%20McDermid<p>I've posted directions on how to use the DtsMappingSurfaceControl (the control behind this capability) on my <a href="http://toddmcdermid.blogspot.com/2009/07/using-dtsmappingsurfacecontrol-in-your.html">blog</a>.  Sample code is included.</p> <hr class=sig> <a href="http://feeds.feedburner.com/~r/ToddMcdermidsBlog/~6/3"><img style="border:0" src="http://feeds.feedburner.com/ToddMcdermidsBlog.3.gif" alt="Todd McDermid's Blog"></a>Sun, 05 Jul 2009 07:12:08 Z2009-07-05T07:12:49Z