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


Overview

Script task to process data flow result into control flow.


Setup

This script task is elegant solution over the issue how to process the result of data flow transformation in SSIS control flow enumeration container. It implements wrapper over standard DataReader destination component. Each enumeration is of type IDataRecord.

You may download sample SSIS package from here. The result of each enumeration is printed in the execution results window.


Requirements

Depends on COZYROC Script Task Plus component for implementing parameters user interface.
Depends on COZYROC Package Connection Manager for accessing package object.
Requires installation of COZYROC SSIS+ 1.3 library.


Related technology


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.ScriptTask
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus
  • Microsoft.SqlServer.DTSPipelineWrap

ScriptMain