| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
SQL Server Destination Custom Properties |
SQL Server Destination Custom Properties |
chugugrace |
chugu |
03/14/2017 |
sql |
integration-services |
reference |
[!INCLUDEsqlserver-ssis]
The [!INCLUDEssNoVersion] destination has both custom properties and the properties common to all data flow components.
The following table describes the custom properties of the [!INCLUDEssNoVersion] destination. All properties are read/write.
| Property name | Data Type | Description |
|---|---|---|
| AlwaysUseDefaultCodePage | Boolean | Forces the use of the DefaultCodePage property value. The default value of this property is False. |
| BulkInsertCheckConstraints | Boolean | A value that specifies whether the bulk insert checks constraints. The default value of this property is True. |
| BulkInsertFireTriggers | Boolean | A value that specifies whether the bulk insert fires triggers on tables. The default value of this property is False. |
| BulkInsertFirstRow | Integer | A value that specifies the first row to insert. The default value of this property is -1, which indicates that no value has been assigned |
| BulkInsertKeepIdentity | Boolean | A value that specifies whether values can be inserted into identity columns. The default value of this property is False. |
| BulkInsertKeepNulls | Boolean | A value that specifies whether the bulk insert keeps Null values. The default value of this property is False. |
| BulkInsertLastRow | Integer | A value that specifies the last row to insert. The default value of this property is -1, which indicates that no value has been assigned. |
| BulkInsertMaxErrors | Integer | A value that specifies the number of errors that can occur before the bulk insert stops. The default value of this property is -1, which indicates that no value has been assigned. |
| BulkInsertOrder | String | The names of the sort columns. Each column can be sorted in ascending or descending order. If multiple sort columns are used, the column names are separated by commas. |
| BulkInsertTableName | String | The [!INCLUDEssNoVersion] table or view in the database to which the data is copied. |
| BulkInsertTablock | Boolean | A value that specifies whether the table is locked during the bulk insert. The default value of this property is True. |
| DefaultCodePage | Integer | The code page to use when code page information is not available from the data source. |
| MaxInsertCommitSize | Integer | A value that specifies the maximum number of rows to insert in a batch. When the value is zero, all rows are inserted in a single batch. |
| Timeout | Integer | A value that specifies the number of seconds the [!INCLUDEssNoVersion] destination waits before termination if there is no data available for insertion. A value of 0 means that the [!INCLUDEssNoVersion] destination will not time out. The default value of this property is 30. |
The input and the input columns of the [!INCLUDEssNoVersion] destination have no custom properties.
For more information, see SQL Server Destination.