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


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.


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.


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