InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 08:28:02 GMT20http://www.sqlservercentral.com/Forums/Topic1034782-148-1.aspxDeveloping custom data flow component is not pretty. May I ask you how would you know which columns are mapped to which destination table columns? Are you going to have a special control table with metadata? Perhaps there might be another solution available.Another question can you elaborate in what data flows you want to use this component? Is it straight transfer or you have different transformations preceding this destination table?Thu, 16 Dec 2010 08:44:22 GMTCozyRochttp://www.sqlservercentral.com/Forums/Topic1034782-148-1.aspxPhil Thanks for your suggestion,I really like it and prefer it too, but still I have to develop a script for this, as this is assigned to me.Is it so diificult to build a custom task...@RaunakMy requirement:requirement is to build a custom destination adapter, to map a particular tables column that is used again and again in my packages....The task should accept a connection manager and just map columns of the table required...The initial requirement is this but can extend in future by adding certain transformation codes to it...as its repeated steps in all the packages..hope its clear..I did find some detination adapters in this link but not sure where to look for the sample code...pasting the link as its very useful one [url]http://ssisctc.codeplex.com/[/url]Wed, 15 Dec 2010 07:53:56 GMTLearner1http://www.sqlservercentral.com/Forums/Topic1034782-148-1.aspxPhil has suggested a great resource!!Just out my sheer curiosity...what custom ability you desire to add?:-)Wed, 15 Dec 2010 05:16:12 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic1034782-148-1.aspx[url=http://msdn.microsoft.com/en-us/library/ms136078.aspx]This[/url] might help you.Your description is a little terse, but I get the gist. No matter how many times you have to map the columns of the table you are referring to, I still suspect that it will take less time than developing a custom component :-)Wed, 15 Dec 2010 00:46:38 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1034782-148-1.aspxHi all.I am very new to SSIS custom data flow components...I have to build a data flow destination custom component , that will be used to map columns of a particular table....Actually the requirement is that we have a table that is used as a destination in several packages and we have to map it again and again...now we want to have a component that just takes the connection manager and maps all the columns of that table...Is there anything like this that can be build in SSIS...?Any help is appreciated...Tue, 14 Dec 2010 14:40:04 GMTLearner1