Hi 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... Thanks

Sure you can. There's quite a bit of documentation in BOL, but you may find more value in looking at code samples instead. I've compiled a list of destination components over at the SSIS Community Tasks and Components site - a lot of them have source code for you to review. Talk to me now on

Hi , Thanks for your reply Can you please send me some steps, which I can follow to do the same, Your website has lot of stuff, I am not sure which one applies to my requirement. ThanksThanks

Download the Adventureworks database for SQL Server and try some of the custom connections in the link below. http://msftisprodsamples.codeplex.com/wikipage?title=SS2008!Creating%20a%20Custom%20Connection%20Manager%20Sample&referringTitle=Home&ProjectName=msftisprodsamples/ Please 'Mark as Answer' if found helpful - Chris@tier-1-support

Thanks for your response, but I think the requirement is not clear here, I dont want to build a custom Connection Manager, I have to build a custom Destination Adapter... Thanks

Priya - I can't do your job for you. The descriptions of the various destinations should give you an idea as to what they do. Pick one or two that sound simple. Open the code and read through it, compile it for yourself and add the component to a test package. Attach the debugger to your BIDS session and use regular debugging techniques to see which methods are called and when, and what each method does. Talk to me now on

It's not that I want you to provide me code for any sample adapter not a readymade adapter, The website shows me many destination adapters but only give me .msi file or .dll file for them not the class file, I cannot see the source code anywhere, for example : for the sample of MERGE Destination ADAPTER , I found only this link http://www.bigresource.com/Tracker/Track-ms_sql-KVzNqlPG/ but this is a readymade destination adapter I can use it directly but can not create it as code is not shown, I want to create one, Can you let me know where can I find the coding for this MERGE DESTINATION adapter in the website given by you. That may help me to build mine destination adapter. Thanks

Go to the "Source" tab. The MERGE component's source (for example) is here. Talk to me now on