ExecuteSql

Namespace: Chimayo.Ssis.Ast.ControlFlowApi

API for working with execute sql tasks

Nested types and modules

ModuleDescription
ParameterBindings

API for working with execute sql task parameter bindings

ResultBindings

API for working with execute sql task result bindings

Functions and values

Function or valueDescription
create name connectionMgr
Signature: name:string -> connectionMgr:string -> CftExecutable
createSimple name connectionMgr sql
Signature: name:string -> connectionMgr:string -> sql:string -> CftExecutable
getBypassPrepare
Signature: CftExecutable -> bool
getCodePage
Signature: CftExecutable -> int
getConnection
Signature: CftExecutable -> CfRef
getIsStoredProc
Signature: CftExecutable -> bool
getSqlSource
Signature: CftExecutable -> CfIndirectSource
getTimeoutSeconds
Signature: CftExecutable -> int
setBypassPrepare bypassPrepare
Signature: bypassPrepare:bool -> CftExecutable -> CftExecutable
setCodePage codePage
Signature: codePage:int -> CftExecutable -> CftExecutable
setConnection connectionManagerName
Signature: connectionManagerName:string -> CftExecutable -> CftExecutable
setIsStoredProc isStoredProc
Signature: isStoredProc:bool -> CftExecutable -> CftExecutable
setSqlFromFile connectionManagerName
Signature: connectionManagerName:string -> CftExecutable -> CftExecutable
setSqlFromVariable variableName
Signature: variableName:string -> CftExecutable -> CftExecutable
setSqlIndirect source
Signature: source:CfRef -> CftExecutable -> CftExecutable
setSqlSource source
Signature: source:CfIndirectSource -> CftExecutable -> CftExecutable
setSqlStatement sql
Signature: sql:string -> CftExecutable -> CftExecutable
setTimeoutSeconds timeoutSeconds
Signature: timeoutSeconds:int -> CftExecutable -> CftExecutable