OleDbDestination

Namespace: Chimayo.Ssis.Ast.DataFlowApi

API for creating and manipiulating OLE DB Destination pipeline components

Functions and values

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

Add a column

add_columns
Signature: DfOleDbDestinationColumn list -> DfComponent -> DfComponent

Add multiple columns

build_fast_load_options (...)
Signature: keepIdentity:bool -> keepNulls:bool -> maxRowsPerCommit:int -> options:DfOleDbDestinationFastLoadOption list -> DfOleDbDestinationFastLoadSettings

Construct an instance of DfOleDbDestinationFastLoadSettings

clear_columns
Signature: DfComponent -> DfComponent

Removes all 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 an OLE DB Destination component and then apply a series of transformations

define_column (...)
Signature: externalName:string -> externalDataType:DfDataType -> sourceColumnRef:DfInputColumnReference option -> DfOleDbDestinationColumn

Construct a new OLE DB Destination column definition

define_columns_for_source (...)
Signature: componentName:string -> outputName:string -> (string * DfDataType * string) list -> DfOleDbDestinationColumn list

Construct multiple OLE DB Destination column definitions from a list of tuples of (externalName, externalDataType, sourceColumnName)

disconnect_input
Signature: DfComponent -> DfComponent

Removes the connection, if any

error_output_name
Signature: string

Defined name of the OLE DB Destination error output. Has to match SSIS internals.

get
Signature: DfComponent -> DfOleDbDestinationConfiguration

Alias for ingress

get_always_use_default_codepage
Signature: DfComponent -> bool

Get the always use default code page flag

get_column_by_external_name externalName
Signature: externalName:String -> DfComponent -> DfOleDbDestinationColumn

Gets a column based on its external name

get_columns
Signature: DfComponent -> DfOleDbDestinationColumn list

Get the columns

get_connection
Signature: DfComponent -> CfRef

Get the connection

get_default_codepage
Signature: DfComponent -> int

Get the default code page

get_error_row_disposition
Signature: DfComponent -> DfOutputColumnRowDisposition

Get the error row disposition

get_target
Signature: DfComponent -> DfOleDbDestinationTarget

Get the target

get_timeout_seconds
Signature: DfComponent -> int

Get the timeout

input_name
Signature: string

Defined name of the OLE DB Destination input. Has to match SSIS internals.

remove_all_columns
Signature: DfComponent -> DfComponent

Removes all columns

remove_column_by_external_name (...)
Signature: externalName:String -> DfComponent -> DfComponent

Removes a column based on its external name

set_always_use_default_codepage enabled
Signature: enabled:bool -> DfComponent -> DfComponent

Set the always use default code page flag

set_connection conn
Signature: conn:string -> DfComponent -> DfComponent

Set the connection

set_default_codepage codePage
Signature: codePage:int -> DfComponent -> DfComponent

Set the default code page

set_error_row_disposition disposition
Signature: disposition:DfOutputColumnRowDisposition -> DfComponent -> DfComponent

Set the error row disposition

set_target t
Signature: t:DfOleDbDestinationTarget -> DfComponent -> DfComponent

Set the target of the pipeline component directly

set_target_sql
Signature: string -> DfComponent -> DfComponent

Retargets the pipelne component to populate a table or view represented by a SQL statement

set_target_table_or_view
Signature: string -> DfComponent -> DfComponent

Retargets the pipelne component to populate a table or view by name

set_target_table_or_view_fast_load (...)
Signature: name:string -> keepIdentity:bool -> keepNulls:bool -> maxRowsPerCommit:int -> options:DfOleDbDestinationFastLoadOption list -> DfComponent -> DfComponent

Retargets the pipelne component to populate a table or view by name with fast load options

set_target_table_or_view_variable
Signature: CfVariableRef -> DfComponent -> DfComponent

Retargets the pipelne component to populate a table or view by name stored in a variable

set_target_table_or_view_variable_fast_load (...)
Signature: variable:CfVariableRef -> keepIdentity:bool -> keepNulls:bool -> maxRowsPerCommit:int -> options:DfOleDbDestinationFastLoadOption list -> DfComponent -> DfComponent

Retargets the pipelne component to populate a table or view by name stored in a variable with fast load options

set_timeout_seconds timeout
Signature: timeout:int -> DfComponent -> DfComponent

Set the timeout