SqlServerSink Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 CopySinkPublic Class SqlServerSink
Inherits CopySink- Inheritance
- 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
Azure SDK for .NET