Delen via


SqlServerSink Class

Definition

A copy activity SQL server sink.

[System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.SqlServerSink+SqlServerSinkConverter))]
public class SqlServerSink : Azure.Analytics.Synapse.Artifacts.Models.CopySink
[<System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.SqlServerSink+SqlServerSinkConverter))>]
type SqlServerSink = class
    inherit CopySink
Public Class SqlServerSink
Inherits CopySink
Inheritance
SqlServerSink
Attributes

Constructors

SqlServerSink()

Initializes a new instance of SqlServerSink.

Properties

AdditionalProperties

Additional Properties.

(Inherited from CopySink)
MaxConcurrentConnections

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

(Inherited from CopySink)
PreCopyScript

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

SinkRetryCount

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

(Inherited from CopySink)
SinkRetryWait

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

(Inherited from CopySink)
SqlWriterStoredProcedureName

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

SqlWriterTableType

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

StoredProcedureParameters

SQL stored procedure parameters.

StoredProcedureTableTypeParameterName

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

TableOption

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

WriteBatchSize

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

(Inherited from CopySink)
WriteBatchTimeout

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

(Inherited from CopySink)

Applies to