SqlServerSink Constructors

Definition

Namespace:

Microsoft.Azure.Management.DataFactory.Models

Assembly:

Microsoft.Azure.Management.DataFactory.dll

Package:

Microsoft.Azure.Management.DataFactory v8.0.0

Overloads

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.

SqlServerSink()

Initializes a new instance of the SqlServerSink class.

public SqlServerSink ();

Public Sub New ()

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.

public SqlServerSink (System.Collections.Generic.IDictionary<string,object> additionalProperties = default, object writeBatchSize = default, object writeBatchTimeout = default, object sinkRetryCount = default, object sinkRetryWait = default, object maxConcurrentConnections = default, object disableMetricsCollection = default, object sqlWriterStoredProcedureName = default, object sqlWriterTableType = default, object preCopyScript = default, object storedProcedureParameters = default, object storedProcedureTableTypeParameterName = default, object tableOption = default, object sqlWriterUseTableLock = default, object writeBehavior = default, Microsoft.Azure.Management.DataFactory.Models.SqlUpsertSettings upsertSettings = default);

new Microsoft.Azure.Management.DataFactory.Models.SqlServerSink : System.Collections.Generic.IDictionary<string, obj> * obj * obj * obj * obj * obj * obj * obj * obj * obj * obj * obj * obj * obj * obj * Microsoft.Azure.Management.DataFactory.Models.SqlUpsertSettings -> Microsoft.Azure.Management.DataFactory.Models.SqlServerSink

Public Sub New (Optional additionalProperties As IDictionary(Of String, Object) = Nothing, Optional writeBatchSize As Object = Nothing, Optional writeBatchTimeout As Object = Nothing, Optional sinkRetryCount As Object = Nothing, Optional sinkRetryWait As Object = Nothing, Optional maxConcurrentConnections As Object = Nothing, Optional disableMetricsCollection As Object = Nothing, Optional sqlWriterStoredProcedureName As Object = Nothing, Optional sqlWriterTableType As Object = Nothing, Optional preCopyScript As Object = Nothing, Optional storedProcedureParameters As Object = Nothing, Optional storedProcedureTableTypeParameterName As Object = Nothing, Optional tableOption As Object = Nothing, Optional sqlWriterUseTableLock As Object = Nothing, Optional writeBehavior As Object = Nothing, Optional upsertSettings As SqlUpsertSettings = Nothing)

Parameters

additionalProperties

IDictionary<String,Object>

Unmatched properties from the message are deserialized this collection

writeBatchSize

Object

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

writeBatchTimeout

Object

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

sinkRetryCount

Object

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

sinkRetryWait

Object

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

maxConcurrentConnections

Object

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

disableMetricsCollection

Object

If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).

sqlWriterStoredProcedureName

Object

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

sqlWriterTableType

Object

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

preCopyScript

Object

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

storedProcedureParameters

Object

SQL stored procedure parameters.

storedProcedureTableTypeParameterName

Object

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

tableOption

Object

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

sqlWriterUseTableLock

Object

Whether to use table lock during bulk copy. Type: boolean (or Expression with resultType boolean).

writeBehavior

Object

Write behavior when copying data into sql server. Type: SqlWriteBehaviorEnum (or Expression with resultType SqlWriteBehaviorEnum)

upsertSettings

SqlUpsertSettings

SQL upsert settings.