DerivedColumn

Namespace: Chimayo.Ssis.Ast.DataFlowApi

API for creating and manipiulating Derived Column pipeline components

Functions and values

Function or valueDescription
add_column column c
Signature: column:DfDerivedColumnColumn -> c:DfComponent -> DfComponent

Add a column to the pipeline component

add_columns
Signature: DfDerivedColumnColumn list -> DfComponent -> DfComponent

Add multiple columns to the pipeline component

clear_columns
Signature: DfComponent -> DfComponent

Clear all output columns

connect_input
Signature: DfComponent -> string -> DfComponent -> DfComponent

Connects two pipeline components

connect_input_by_name
Signature: string -> string -> DfComponent -> DfComponent

Connects two pipeline components

create name adapters
Signature: name:string -> adapters:(DfComponent -> DfComponent) list -> DfComponent

Create a new instance of a Derived Column component and then apply a series of transformations

define_column name dataType expression
Signature: name:string -> dataType:DfDataType -> expression:DfExpression -> DfDerivedColumnColumn

Constructs a new Derived Column column that produces a new output column

disconnect_input
Signature: DfComponent -> DfComponent

Removes the connection, if any

error_output_name
Signature: string

Defined name of the Derived Column error output. Has to match SSIS internals.

get
Signature: DfComponent -> DfDerivedColumnConfiguration

Alias for ingress

get_columns
Signature: DfComponent -> DfDerivedColumnColumn list

Get the columns of the pipeline component

input_name
Signature: string

Defined name of the Derived Column input. Has to match SSIS internals.

output_name
Signature: string

Defined name of the Derived Column output. Has to match SSIS internals.

replace_column sourceColumn expression
Signature: sourceColumn:DfInputColumnReference -> expression:DfExpression -> DfDerivedColumnColumn

Constructs a new Derived Column column that replaces the value of an input column