No votes yet


Overview

Data flow transformation, repeating a row number of times. The repeat amount is specified in a column.


Setup

The script has the following parameters:

  • RepeatColumn - selects input column containing rows repeat amount.

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

ScriptMain