Use the Inputs and Outputs page of the Script Transformation Editor dialog box to add, remove, and configure inputs and outputs for the Script Transformation.
Source components have outputs and no inputs, while destination components have inputs but no outputs. Transformations have both inputs and outputs.
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.
Inputs and outputs
Select an input or output on the left to view its properties in the table on the right. Properties available for editing vary according to the selection. Many of the properties displayed are read-only. For more information on the individual properties, see the following topics.
Add an additional output to the list.
Select a folder in which to place the new output column, and then add the column by clicking Add Column.
Select an output, and then remove it by clicking Remove Output.
Select a column, and then remove it by clicking Remove Column.
Integration Services Error and Message Reference
Select Script Component Type
Script Transformation Editor (Input Columns Page)
Script Transformation Editor (Script Page)
Script Transformation Editor (Connection Managers Page)
Additional Script Component Examples