Biml Language Reference
DerivedColumn Element
AstDerivedColumnNode enables the definition of new columns in a dataflow task within a Derived Columns transformation.
Attributes
  Attribute API Type Default Description
CodePage Int32
This value specifies the integer index for the codepage of the derived column. This property applies only to derived 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.

[.NET API Property: CodePage]

DataType DbType
This value specifies the type of the derived column node using a .NET DbType.

[.NET API Property: DataType]

Length Int32
This value specifies the length parameter for the column type associated with this column. This property applies only to column types that support a length specification, such as String and Binary types.

[.NET API Property: Length]

Name String
Specifies the name of the object. This name can be used to reference this object from anywhere else in the program.

[.NET API Property: Name]

Precision Int32
This value specifies the precision, or the number of digits in a value. This property applies only to derived column types that support precision, such as decimal.

[.NET API Property: Precision]

ReplaceExisting Boolean
This value specifies whether this derived column definition should (1) replace an existing derived column definition with the same name or (2) create a new derived column with its own unique lineage.

[.NET API Property: ReplaceExisting]

Scale Int32
This value specifies the scale, the number of digits to the right of the decimal point in a value. This property applies only to derived column types that support precision, such as decimal.

[.NET API Property: Scale]

SsisDataTypeOverride SsisDataType
Specifies the SSIS Data Type that should be used for the output column. This value overrides the value specified in the DataType property.

[.NET API Property: SsisDataTypeOverride]

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.

[.NET API Property: Annotations]