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.