SqlServerSource 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 source.

public class SqlServerSource : Microsoft.Azure.Management.DataFactory.Models.TabularSource

type SqlServerSource = class
    inherit TabularSource

Public Class SqlServerSource
Inherits TabularSource

Inheritance

Object

CopySource

TabularSource

SqlServerSource

Constructors

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

Properties

AdditionalColumns	Gets or sets specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects). (Inherited from TabularSource)
AdditionalProperties	Gets or sets unmatched properties from the message are deserialized this collection (Inherited from CopySource)
DisableMetricsCollection	Gets or sets if true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean). (Inherited from CopySource)
MaxConcurrentConnections	Gets or sets the maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer). (Inherited from CopySource)
PartitionOption	Gets or sets the partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange".
PartitionSettings	Gets or sets the settings that will be leveraged for Sql source partitioning.
ProduceAdditionalTypes	Gets or sets which additional types to produce.
QueryTimeout	Gets or sets query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])). (Inherited from TabularSource)
SourceRetryCount	Gets or sets source retry count. Type: integer (or Expression with resultType integer). (Inherited from CopySource)
SourceRetryWait	Gets or sets source 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 CopySource)
SqlReaderQuery	Gets or sets SQL reader query. Type: string (or Expression with resultType string).
SqlReaderStoredProcedureName	Gets or sets name of the stored procedure for a SQL Database source. This cannot be used at the same time as SqlReaderQuery. Type: string (or Expression with resultType string).
StoredProcedureParameters	Gets or sets value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".