Script Transformation Editor (Input Columns Page)

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

Note

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.

Options

  • 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 Columns table.
  • 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.

See Also

Reference

Select Script Component Type
Script Transformation Editor (Inputs and Outputs Page)
Script Transformation Editor (Script Page)
Script Transformation Editor (Connection Managers Page)

Other Resources

Integration Services Error and Message Reference
Additional Script Component Examples

Help and Information

Getting SQL Server 2005 Assistance