Flat File Column Element
X-Ref:
- Ast Flat File Column Node
- Ast File Column 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 | |
| ColumnType | FlatFileColumnType | Delimited | This value specifies the type of the column in in the flat file format. |
| DataType | DbType | Int32 | This value specifies the type of the dataflow column node using a .NET DbType. |
| Delimiter | Delimiter | CRLF | This value specifies the delimiter string that will be used to mark the end of this column. |
| FastParse | Boolean | False | Indicates that SSIS should parse the column using locale-neutral methods. |
| Id | Guid | 00000000-0000-0000-0000-000000000000 | Allows the developer to specify a unique identifier (GUID) for the flat file column. This can be used to retain a consistent ID between builds. |
| InputLength | Int32 | 0 | This value specifies the length of the input for fixed width column. |
| 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. |
| MaximumWidth | Int32 | 0 | Specifies the maximum width for the column. If this value is not specified, the Length value is used instead. |
| 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. |
| 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. |
| TextQualified | Boolean | True | This value indicates whether string values may be wrapped in text qualifiers. This enables string or text blocks to include the delimiter string. |
| UseBinaryFormat | Boolean | False | Indicates that the data is in binary format. |
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. |