Data Conversion Column Element
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| DataType | DbType | This value specifies the type of the converted column using the unified type system. This is a required property | |
| SourceColumn | String | This value specifies the name of the source column in the data flow path mapping. This is a required property | |
| CodePage | Int32 | 0 | This value specifies the integer index for the code page of this converted column type. This property applies only to converted column types that support code pages, such as strings. Code pages supported by Windows are listed at: http://msdn.microsoft.com/en-us/goglobal/bb964654.aspx. |
| FastParse | Boolean | False | This value specifies whether a column uses SQL Server Integration Services (SSIS) fast parsing routines. |
| IsUsed | Boolean | True | This value specifies whether the dataflow column is used. |
| Length | Int32 | 0 | This value specifies the length of the converted column type. This property applies only to converted column types that support a length specification, such as string and binary types. |
| Precision | Int32 | 0 | This value specifies the precision or the number of digits in a converted column type. This property only applies to converted column types that support precision, such as decimal. |
| Scale | Int32 | 0 | This value specifies the precision, or the number of digits, in a converted column type. This property applies only to converted column types that support precision, such as decimal. |
| SortKeyPosition | Int32 | 0 | This value specifies where the parent column is situated in the sort order. For example if the rows were first sorted by 2 other columns, then the value would be 3. If this column was not used for sorting, it's value should be 0. |
| SsisDataTypeOverride | SsisDataType | Varigence.Utility.DataType.SsisDataType.DT_EMPTY | Specifies the SSIS Data Type that should be used for the output column. This value overrides the value specified in the DataType property. |
| TargetColumn | String | This value specifies the name of the destination column in the data flow path mapping. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |