Use the Connection Managers page of the Script Transformation Editor to specify any connections that will be used by the script.
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.
View the list of connections available for use by the script.
Type a unique and descriptive name for the connection.
Select from the list of available connection managers, or select <New connection> to open the Add SSIS Connection Manager dialog box.
Type a description for the connection.
Add another connection to the Connection managers list.
Remove the selected connection from the Connection managers list.
Integration Services Error and Message Reference
Select Script Component Type
Script Transformation Editor (Input Columns Page)
Script Transformation Editor (Inputs and Outputs Page)
Script Transformation Editor (Script Page)
Additional Script Component Examples