DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Average: 4 (3 votes)


Overview

Data flow source, used to setup test data. The first row contains the column names and each row of data is separated with newline.


Setup

The script has the following parameters:

  • Data - specifies test data.
  • ColumnDelimiter - specifies column delimiter. Optional.

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