SqlServerSink Class

Definition

Namespace:

Microsoft.Azure.Management.DataFactory.Models

Assembly:

Microsoft.Azure.Management.DataFactory.dll

Package:

Microsoft.Azure.Management.DataFactory v8.0.0

A copy activity SQL server sink.

public class SqlServerSink : Microsoft.Azure.Management.DataFactory.Models.CopySink

type SqlServerSink = class
    inherit CopySink

Public Class SqlServerSink
Inherits CopySink

Inheritance

Object

CopySink

SqlServerSink

Constructors

SqlServerSink()	Initializes a new instance of the SqlServerSink class.
SqlServerSink(IDictionary<String,Object>, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, SqlUpsertSettings)	Initializes a new instance of the SqlServerSink class.

Properties

AdditionalProperties	Gets or sets unmatched properties from the message are deserialized this collection (Inherited from CopySink)
DisableMetricsCollection	Gets or sets if true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean). (Inherited from CopySink)
MaxConcurrentConnections	Gets or sets the maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer). (Inherited from CopySink)
PreCopyScript	Gets or sets SQL pre-copy script. Type: string (or Expression with resultType string).
SinkRetryCount	Gets or sets sink retry count. Type: integer (or Expression with resultType integer). (Inherited from CopySink)
SinkRetryWait	Gets or sets 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	Gets or sets SQL writer stored procedure name. Type: string (or Expression with resultType string).
SqlWriterTableType	Gets or sets SQL writer table type. Type: string (or Expression with resultType string).
SqlWriterUseTableLock	Gets or sets whether to use table lock during bulk copy. Type: boolean (or Expression with resultType boolean).
StoredProcedureParameters	Gets or sets SQL stored procedure parameters.
StoredProcedureTableTypeParameterName	Gets or sets the stored procedure parameter name of the table type. Type: string (or Expression with resultType string).
TableOption	Gets or sets the option to handle sink table, such as autoCreate. For now only 'autoCreate' value is supported. Type: string (or Expression with resultType string).
UpsertSettings	Gets or sets SQL upsert settings.
WriteBatchSize	Gets or sets write batch size. Type: integer (or Expression with resultType integer), minimum: 0. (Inherited from CopySink)
WriteBatchTimeout	Gets or sets 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)
WriteBehavior	Gets or sets write behavior when copying data into sql server. Type: SqlWriteBehaviorEnum (or Expression with resultType SqlWriteBehaviorEnum)