Devart SQL Server Destination component loads data into SQL Server tables. It has the following custom properties:
Property
|
Description
|
BufferSize
|
The maximal size of a data packet sent to the server. Default value is 262144.
|
BulkInsertMode
|
Determines which mode is used to load external data to a SQL Server database. Default value is Text. The following values are supported:
| • | Text - the text mode is used, which is the only option available for SQL Server 7.3 and older. |
| • | Binary - the binary mode is used, which is faster, but supported only within protocol 3.0. |
|
Operation
|
A DML operation to apply to the target object. Default value is BulkInsert. The following values are supported:
| • | Insert - This is the most common operation. |
| • | Update - Devart SQL Server Destination component in the Update mode enables updating data in a data source. Peculiarity of this action consists in the fact, that performing it requires using primary key values of the target table (the Id value for cloud sources). Thus, when performing an update, you must know and specify the primary key values of the target table to update a record. |
| • | Delete - Devart SQL Server Destination component in the Delete mode enables deleting data from a data source. As well as for the update operation, you must know and specify the primary key values of the target table to delete a record. |
| • | BulkInsert - Devart SQL Server Destination component uses the COPY command to speed up data loading. |
|
RetryCount
|
The number of times to retry loading the data in case if it fails. Default value is 5.
|
RetryInterval
|
The number of seconds before repeating an attempt to load data. Default value is 1.
|
TableName
|
The name of a SQL Server database object to load data into.
|