Data Record To Variable Task

No votes yet


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.


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