Dataflow Output Column Element
X-Ref:
- Ast Dataflow Output Column Node
- Ast Dataflow Column Node
- Ast Dataflow Column Base Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| Name | String | Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property | |
| CodePage | Int32 | 0 | This value specifies the integer index for the codepage of the dataflow column. This property applies only to dataflow column types that support code pages, such as strings. Codepages supported by Windows are listed at: http://msdn.microsoft.com/en-us/goglobal/bb964654.aspx. |
| DataType | DbType | Int32 | This value specifies the type of the dataflow column node using a .NET DbType. |
| ErrorOrTruncationOperation | String | Defines the operations that may cause truncations or errors. | |
| ErrorRowDisposition | ErrorRowDisposition | NotUsed | Defines how errors for this column are handled by the component. |
| ExternalMetadataColumnName | AstDataflowExternalColumnNode | Defines the external column related to this output column. This references an existing definiton. | |
| Length | Int32 | 0 | This value specifies the length for the dataflow column type. This property applies only to column types that support a length specification, such as String and Binary types. |
| LineageId | Int32 | 0 | This value specifies the LineageId that will be used for this column during creation of the SQL Server Integration Services package. Under normal circumstances, this value will be populated automatically by the Biml compiler. |
| Precision | Int32 | 0 | This value specifies the precision, or the number of digits in a value. This property applies only to dataflow column types that support precision, such as decimal. |
| Scale | Int32 | 0 | This value specifies the scale, the number of digits to the right of the decimal point in a value. This property applies only to dataflow column types that support precision, such as decimal. |
| SortOrder | SortOrder | Asc | Specifies the order (ascending or descending) of the column's sort order for the output. This property should only be set for components that produce sorted output - a Sort transform or a source component that allows specification of sort order. |
| SortPosition | Int32 | 0 | Specifies the column's position in the sort order for the output. This property should only be set for components that produce sorted output - a Sort transform or a source component that allows specification of sort order. |
| SourceColumn | String | Defines the upstream column that is mapped to this column. Not used if this is a column created by this component. | |
| 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. |
| TruncationRowDisposition | TruncationRowDisposition | NotUsed | Defines how truncations for this column are handled by the component. |
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. |
| <ComparisonFlags> <ComparisonFlag /> </ComparisonFlags> | ComparisonFlags | Sets the string comparision values to use for this column. |
| <CustomProperties> <Property /> </CustomProperties> | AstDataflowPropertyNode | This is a collection of optional custom property definitions that are support on this dataflow column. |