Merge Setup Transformation

DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
No votes yet

Script File: 
MergeSetup.2005.scx
MergeSetup.2008.scx10
MergeSetup.2012.scx11
MergeSetup.2014.scx12

Overview

Data flow transformation, which setups temporary stage table for specified destination table in the data flow pre-execute phase. The content of the temporary table is inserted in the destination table in the data flow post-execute phase, using the new SQL 2008 MERGE (Transact-SQL) statement.

Setup

The script has the following parameters:

  • Connection - specifies ADO.NET connection manager.
  • IsTableVariable - indicates whether table name is stored in variable.
    • Table - selects destination table.
    • TableVariable - selects variable containing destination table.
  • PrimaryKeys - selects destination table primary key columns.
  • StageVariable - selects variable to store temporary stage table name. Use this variable in the destination data flow component.

Requirements

Depends on COZYROC Script Component Plus for implementing parameters user interface.

Library references

  • System
  • System.Data
  • Microsoft.SqlServer.TxScript
  • Microsoft.SqlServer.PipelineHost
  • Microsoft.SqlServer.DTSPipelineWrap
  • Microsoft.SqlServer.DTSRuntimeWrap
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus
  • System.XML

ScriptMain