Adf Sql Server Sink Element
X-Ref:
- Ast Adf Sql Server Sink Node
- Ast Adf Sql Server Database Sink Base Node
- Ast Adf Pre Copy Script Sink Base Node
- Ast Adf Dataset Sink Base Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| DatasetName | AstAdfSqlServerDatasetNode | Specifies a reference to the SqlServer dataset that will receive the data. This is a required reference to an existing definiton. | |
| MaxConcurrentConnections | Int32 | 0 | Max number of simultaneous connections to the source. |
| RetryCount | Int32 | 0 | Number of retries. |
| RetryWait | String | String representing the retry wait. Pattern: ((\\d+)\\.)?(\\d\\d):(60|([0-5][0-9])):(60|([0-5][0-9])) | |
| StoredProcedure | String | Name of the Stored Procedure that is being used to upsert data into the sink. | |
| StoredProcedureTableTypeParameterName | String | The name of the stored procedure parameter of the table type. | |
| TableType | String | Specifies a table type for Stored Procedure usage. Copy activities make moving data available in a temporary table with this specified type. This allows the stored procedure code to merge the data being copied with existing data. | |
| WriteBatchSize | Int32 | -1 | Specifies the number of rows that should be stored in the write buffer before sending to the sink dataset. |
| WriteBatchTimeout | String | Specifies the timespan that the activity should wait for the sink dataset before raising an error. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <PreCopyScript /> | String | String is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
| <Parameters> <Parameter /> </Parameters> | AstAdfCopyActivityParameterNode | Specifies the Dataset parameters to be used. |
| <StoredProcedureParameters> <Parameter /> </StoredProcedureParameters> | AstAdfStoredProcedureParameterNode | This collection contains the parameters that will be passed to the stored produre for execution. |