Data Record To Variable Task

No votes yet

Overview

Script task, which extracts field information from IDataRecord object into SSIS variables. The variable names have to match the field names. 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