Sql
A copy activity SQL server source.
Constructors
Properties
Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).
If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).
Specifies the transaction locking behavior for the SQL source. Allowed values: ReadCommitted/ReadUncommitted/RepeatableRead/Serializable/Snapshot. The default value is ReadCommitted. Type: string (or Expression with resultType string).
The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer).
The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange". Type: string (or Expression with resultType string).
The settings that will be leveraged for Sql source partitioning.
Which additional types to produce.
Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+)\.)?(\d\d):(60|(0-9)):(60|(0-9)).
Source retry count. Type: integer (or Expression with resultType integer).
Source retry wait. Type: string (or Expression with resultType string), pattern: ((\d+)\.)?(\d\d):(60|(0-9)):(60|(0-9)).
SQL reader query. Type: string (or Expression with resultType string).
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).
Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".