SQL Server Destination Custom Properties
The SQL Server destination has both custom properties and the properties common to all data flow components.
The following table describes the custom properties of the SQL Server 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 SQL Server 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 SQL Server destination waits before termination if there is no data available for insertion. A value of 0 means that the SQL Server destination will not time out. The default value of this property is 30. |
The input and the input columns of the SQL Server destination have no custom properties.
For more information, see SQL Server Destination.