MERGE Destination

Rating:        Based on 4 ratings
Reviewed:  4 reviews
Downloads: 4546
Released: Nov 4, 2008
Updated: Apr 18, 2012 by MattCarroll
Dev status: Beta Help Icon

Recommended Download

Documentation MergeDestinationReadme_SQL2012.rtf
documentation, 196K, uploaded Apr 18, 2012 - 701 downloads

Other Available Downloads

Application TVPMergeDestSetup
application, 555K, uploaded Nov 5, 2008 - 3562 downloads
Application MergeDestinationSetup_SQL2012.msi
application, 68K, uploaded Apr 18, 2012 - 283 downloads

Release Notes

SQL Server can use the MERGE statement to perform an upsert operation efficiently, by batching rows of data instead of processing rows one at a time. However, Integration Services does not currently provide a built-in destination component that supports the use of MERGE. This sample demonstrates one way to encapsulate MERGE functionality within an Integration Services data flow component.

Reviews for this release

     
Near every edit results in validation errors where the properties can no longer be edited via the normal interface, and the advanced editor does not appear to allow modification of the properties causing the validation issues, so you have to delete the component and start over again.
by K_Dahl on Dec 7, 2012 at 4:30 PM
     
Pragmaticworks has similar production ready component call Upsert Destination. It supports 4 different type of Upsert and planning to add Type2 Upsert very soon. http://pragmaticworks.com/products/Business-Intelligence/taskfactory/ssis-tasks-xml-sftp-zip-upsert.aspx
by SSISGuy on Jan 18, 2011 at 9:53 PM
     
It could be a very good component, but it doesn't work.
by mlourinho on Dec 17, 2010 at 4:49 PM
     
The concept is very good. Unfortunatly at this point, the component is in beta phase and got many errors. Hope the component will be developed finished.
by wirr on May 13, 2009 at 8:34 AM