Export (0) Print
Expand All
Expand Minimize

Script Transformation Editor (Input Columns Page)

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

ms189428.note(en-US,SQL.90).gifNote:
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 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft