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.

See Also

Common Properties