RSS

All Project Updates

Discussions

Issue Tracker

Releases

Reviews

Source Code

Wiki & Documentation

RSS

MERGE Destination

Released:	Nov 4 2008
Updated:	Nov 5 2008 by dnoor
Dev status:	Beta
Rated:	based on 1 rating (Add your own rating)
Reviewed:	1 review
Downloaded:	1025 downloads
Wiki link:	[release:19048]

TVPMergeDestSetup

application, 555K, uploaded Nov 5 2008 - 1025 downloads

Microsoft Public License (Ms-PL)

This license governs use of the accompanying software. If you use the software, you accept this license. If you do not accept the license, do not use the software.

1. Definitions

The terms "reproduce," "reproduction," "derivative works," and "distribution" have the same meaning here as under U.S. copyright law.

A "contribution" is the original software, or any additions or changes to the software.

A "contributor" is any person that distributes its contribution under this license.

"Licensed patents" are a contributor's patent claims that read directly on its contribution.

2. Grant of Rights

(A) Copyright Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free copyright license to reproduce its contribution, prepare derivative works of its contribution, and distribute its contribution or any derivative works that you create.

(B) Patent Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free license under its licensed patents to make, have made, use, sell, offer for sale, import, and/or otherwise dispose of its contribution in the software or derivative works of the contribution in the software.

3. Conditions and Limitations

(A) No Trademark License- This license does not grant you rights to use any contributors' name, logo, or trademarks.

(B) If you bring a patent claim against any contributor over patents that you claim are infringed by the software, your patent license from such contributor to the software ends automatically.

(C) If you distribute any portion of the software, you must retain all copyright, patent, trademark, and attribution notices that are present in the software.

(D) If you distribute any portion of the software in source code form, you may do so only under this license by including a complete copy of this license with your distribution. If you distribute any portion of the software in compiled or object code form, you may only do so under a license that complies with this license.

(E) The software is licensed "as-is." You bear the risk of using it. The contributors give no express warranties, guarantees or conditions. You may have additional consumer rights under your local laws which this license cannot change. To the extent permitted under your local laws, the contributors exclude the implied warranties of merchantability, fitness for a particular purpose and non-infringement.

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.

Releases

Released | Planned

	SharePoint List Source and Destination Mar 17 2009, Stable
	EzAPI - Package Generation API Dec 30 2008, Stable
	BizTalk to Integation Services Samples Nov 12 2008, Stable
	MERGE Destination Nov 4 2008, Beta
	Spatial Data Flow Components Sep 30 2008
	SQL Server Data Services Source and Destination Sep 24 2008, Stable
	WMI Source Sep 24 2008
	Hello World Task Sep 24 2008
	Dynamic Package Generation Sample Sep 24 2008
	Delimited File Reader Source Sep 24 2008
	Regular Expression Flat File Source Sep 24 2008
	XML Destination Sep 24 2008

There are no planned releases for this project.

Reviews for this release

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 at 9:34 AM

Microsoft SQL Server Community Samples: Integration Services

Recommended Download

Release Notes

Releases

Rate this release

Delete MERGE Destination