Package version:

Interface SqlServerSink

A copy activity SQL server sink.

Hierarchy

Properties

maxConcurrentConnections?: any

The maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer).

preCopyScript?: any

SQL pre-copy script. Type: string (or Expression with resultType string).

sinkRetryCount?: any

Sink retry count. Type: integer (or Expression with resultType integer).

sinkRetryWait?: any

Sink retry wait. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

sqlWriterStoredProcedureName?: any

SQL writer stored procedure name. Type: string (or Expression with resultType string).

sqlWriterTableType?: any

SQL writer table type. Type: string (or Expression with resultType string).

storedProcedureParameters?: {
    [propertyName: string]: StoredProcedureParameter;
}

SQL stored procedure parameters.

Type declaration

storedProcedureTableTypeParameterName?: any

The stored procedure parameter name of the table type. Type: string (or Expression with resultType string).

tableOption?: any

The option to handle sink table, such as autoCreate. For now only 'autoCreate' value is supported. Type: string (or Expression with resultType string).

type: "SqlServerSink"

Polymorphic discriminator, which specifies the different types this object can be

writeBatchSize?: any

Write batch size. Type: integer (or Expression with resultType integer), minimum: 0.

writeBatchTimeout?: any

Write batch timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

Generated using TypeDoc