http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/07/the-current-state-of-a-merge-destination-for-ssis.aspxHugo Tap asked me on Twitter earlier today whether or not there existed a SSIS Dataflow Destination component that enabled one to MERGE data into a table rather than INSERT it. Its a common request so I thought it might be useful to summarise the currentenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/07/the-current-state-of-a-merge-destination-for-ssis.aspx#46563Fri, 07 Dec 2012 22:03:46 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46563Kevin<p>I tried this out and it seemed rather sketchy. It's cumbersome to set up and very prone to errors that lead to the component no longer being in a state where you can edit it.</p> <p>However - it did lead me to a much nicer solution of just writing the procedures to use table valued parameters, combined with a recordset and a script task I now have some nice working merge functionality from SSIS.</p> http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/07/the-current-state-of-a-merge-destination-for-ssis.aspx#48449Thu, 28 Mar 2013 16:06:54 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:48449Michael<p>Kevin,</p> <p>Can you blog on the nicer solution? &nbsp;Or Jamie can you pick up that response and give us a demo of that?</p>