Script Transformation Editor (Input Columns Page)

Use the Input Columns page of the Script Transformation Editor dialog box to set properties on input columns.


The Input Columns page is not displayed for Source components, which have outputs but no inputs.

To learn more about the Script component, see Script Component and Configuring the Script Component in the Script Component Editor. To learn about programming the Script component, see Extending the Data Flow with the Script Component.


  • Input name
    Select from the list of available inputs.

  • Available Input Columns
    Using the check boxes, specify the columns that the script transformation will use.

  • Input Column
    Select from the list of available input columns for each row. Your selections are reflected in the check box selections in the Available Input Columnstable.

  • Output Alias
    Type an alias for each output column. The default is the name of the input column; however, you can choose any unique, descriptive name.

  • Usage Type
    Specify whether the Script Transformation will treat each column as ReadOnly or ReadWrite.