SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Integration Services
Technical Reference
Feature Reference
Integration Services F1 Help
SSIS Designer F1 Help
Transformation Properties UI Reference
Advanced Editor (Connection Managers Tab)
Advanced Editor (Component Properties Tab)
Advanced Editor (Column Mappings Tab)
Advanced Editor (Input Columns Tab)
Advanced Editor (Input and Output Properties Tab)
Aggregate Transformation Editor (Aggregations Tab)
Aggregate Transformation Editor (Advanced Tab)
Audit Transformation Editor
Cache Transformation Editor (Connection Manager Page)
Cache Transformation Editor (Mappings Page)
Character Map Transformation Editor
Configure Error Output
Conditional Split Transformation Editor
Copy Column Transformation Editor
Data Conversion Transformation Editor
Data Mining Query Transformation Editor (Mining Model Tab)
Data Mining Query Transformation Editor (Query Tab)
Derived Column Transformation Editor
Export Column Transformation Editor (Columns Page)
Export Column Transformation Editor (Error Output Page)
Fuzzy Grouping Transformation Editor (Connection Manager Tab)
Fuzzy Grouping Transformation Editor (Columns Tab)
Fuzzy Grouping Transformation Editor (Advanced Tab)
Fuzzy Lookup Transformation Editor (Reference Table Tab)
Fuzzy Lookup Transformation Editor (Columns Tab)
Create Relationships
Fuzzy Lookup Transformation Editor (Advanced Tab)
Lookup Transformation Editor (Connection Page)
Lookup Transformation Editor (Advanced Page)
Lookup Transformation Editor (Columns Page)
Lookup Transformation Editor (General Page)
Lookup Transformation Editor (Error Output Page)
Merge Transformation Editor
Merge Join Transformation Editor
Multicast Transformation Editor
Percentage Sampling Transformation Editor
Row Sampling Transformation Editor
Select Script Component Type
Script Transformation Editor (Input Columns Page)
Script Transformation Editor (Inputs and Outputs Page)
Script Transformation Editor (Script Page)
Script Transformation Editor (Connection Managers Page)
Sort Transformation Editor
Term Extraction Transformation Editor (Term Extraction Tab)
Term Extraction Transformation Editor (Exclusion Tab)
Term Extraction Transformation Editor (Advanced Tab)
Term Lookup Transformation Editor (Reference Table Tab)
Term Lookup Transformation Editor (Term Lookup Tab)
Term Lookup Transformation Editor (Advanced Tab)
Union All Transformation Editor
Unpivot Transformation Editor
Expand Minimize
This topic has not yet been rated - Rate this topic

Script Transformation Editor (Input Columns Page)

SQL Server 2008 R2

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

NoteNote

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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.