No votes yet


Overview

Script task to extract field information from IDataRecord object into SSIS variables. The variable names have to match the field names.


Setup

The task has the following parameters:

  • DataRecordVariable - selects variable containing IDataRecord object.

Requirements

Depends on COZYROC Script Task Plus component for implementing parameters user interface.


Library references

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

ScriptMain