Script Transformation Editor (Inputs and Outputs Page)
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.
Note
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.
Options
- 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.
[Common Properties](ms135950\(v=sql.90\).md)
[Source Custom Properties](ms135923\(v=sql.90\).md)
[Transformation Custom Properties](ms136014\(v=sql.90\).md)
[Destination Custom Properties](ms135971\(v=sql.90\).md)
- Add Output
Add an additional output to the list.
- Add Column
Select a folder in which to place the new output column, and then add the column by clicking Add Column.
- Remove Output
Select an output, and then remove it by clicking Remove Output.
- Remove Column
Select a column, and then remove it by clicking Remove Column.
See Also
Reference
Select Script Component Type
Script Transformation Editor (Input Columns Page)
Script Transformation Editor (Script Page)
Script Transformation Editor (Connection Managers Page)
Other Resources
Integration Services Error and Message Reference
Additional Script Component Examples