Script Transformation Editor (Input Columns Page)


Applies To: SQL Server 2016

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

System_CAPS_ICON_note.jpg 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.

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.

Integration Services Error and Message Reference
Select Script Component Type
Script Transformation Editor (Inputs and Outputs Page)
Script Transformation Editor (Script Page)
Script Transformation Editor (Connection Managers Page)
Additional Script Component Examples

Community Additions