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