Average: 5 (1 vote)


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