FlatFileSource

Namespace: Chimayo.Ssis.Ast.DataFlowApi

API for creating and manipulating Flat File Source pipeline components

Functions and values

Function or valueDescription
add_column column
Signature: column:DfFlatFileSourceFileColumn -> DfComponent -> DfComponent

Adds a column to the pipeline component

add_columns
Signature: DfFlatFileSourceFileColumn list -> DfComponent -> DfComponent

Adds multiple columns to the pipeline component

clear_columns
Signature: DfComponent -> DfComponent

Clear all output columns

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

Create a new instance of a Flat File Source component and then apply a series of transformations

default_code_page
Signature: int

Default code page for non-Unicode data

define_column name dataType
Signature: name:string -> dataType:DfDataType -> DfFlatFileSourceFileColumn

Construct a new Flat File Source column definition with values set to appropriate defaults

error_output_column_name
Signature: string

Defined name of the flat file source error output column. Has to match SSIS internals.

error_output_name
Signature: string

Defined name of the flat file source error output. Has to match SSIS internals.

get
Signature: DfComponent -> DfFlatFileSourceConfiguration

Alias for ingress

get_code_page
Signature: DfComponent -> DfFlatFileSourceCodePage

Get the code page for non-Unicode data

get_columns
Signature: DfComponent -> DfFlatFileSourceFileColumn list

Get the columns defined for the pipeline component

get_connection
Signature: DfComponent -> CfRef

Get the connection

get_filename_column_name
Signature: DfComponent -> string

Get the name of the filename column

get_retain_nulls
Signature: DfComponent -> bool

Get the retain NULLs flag

link_connection cm
Signature: cm:CfConnectionManager -> DfComponent -> DfComponent

Link a Flat File Source component to a connection manager and reset code page and columns to match

output_name
Signature: string

Defined name of the flat file source output. Has to match SSIS internals.

set_code_page codePage
Signature: codePage:DfFlatFileSourceCodePage -> DfComponent -> DfComponent

Set the code page for non-Unicode data

set_connection conn
Signature: conn:CfRef -> DfComponent -> DfComponent

Set the connection

set_filename_column_name columnName
Signature: columnName:string -> DfComponent -> DfComponent

Set the name of the filename column

set_retain_nulls enabled
Signature: enabled:bool -> DfComponent -> DfComponent

Set the retain NULLs flag