SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
0 out of 1 rated this helpful - Rate this topic

Data Conversion Transformation Editor

SQL Server 2012

Use the Data Conversion Transformation Editor dialog box to select the columns to convert, select the data type to which the column is converted, and set conversion attributes.

Note Note

The FastParse property of the output columns of the Data Conversion transformation is not available in the Data Conversion Transformation Editor, but can be set by using the Advanced Editor. For more information on this property, see the Data Conversion Transformation section of Transformation Custom Properties.

To learn more about the Data Conversion transformation, see Data Conversion Transformation.

Available Input Columns

Select columns to convert by using the check boxes. Your selections add input columns to the table below.

Input Column

Select columns to convert from the list of available input columns. Your selections are reflected in the check box selections above.

Output Alias

Type an alias for each new column. The default is Copy of followed by the input column name; however, you can choose any unique, descriptive name.

Data Type

Select an available data type from the list. For more information, see Integration Services Data Types.

Length

Set the column length for string data.

Precision

Set the precision for numeric data.

Scale

Set the scale for numeric data.

Code page

Select the appropriate code page for columns of type DT_STR.

Configure error output

Specify how to handle row-level errors by using the Configure Error Output dialog box.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.