TechNet
Export (0) Print
Expand All

SQL Server Destination Custom Properties

 

Applies To: SQL Server 2016

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 nameData TypeDescription
AlwaysUseDefaultCodePageBooleanForces the use of the DefaultCodePage property value. The default value of this property is False.
BulkInsertCheckConstraintsBooleanA value that specifies whether the bulk insert checks constraints. The default value of this property is True.
BulkInsertFireTriggersBooleanA value that specifies whether the bulk insert fires triggers on tables. The default value of this property is False.
BulkInsertFirstRowIntegerA value that specifies the first row to insert. The default value of this property is -1, which indicates that no value has been assigned
BulkInsertKeepIdentityBooleanA value that specifies whether values can be inserted into identity columns. The default value of this property is False.
BulkInsertKeepNullsBooleanA value that specifies whether the bulk insert keeps Null values. The default value of this property is False.
BulkInsertLastRowIntegerA value that specifies the last row to insert. The default value of this property is -1, which indicates that no value has been assigned.
BulkInsertMaxErrorsIntegerA 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.
BulkInsertOrderStringThe 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.
BulkInsertTableNameStringThe SQL Server table or view in the database to which the data is copied.
BulkInsertTablockBooleanA value that specifies whether the table is locked during the bulk insert. The default value of this property is True.
DefaultCodePageIntegerThe code page to use when code page information is not available from the data source.
MaxInsertCommitSizeIntegerA 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.
TimeoutIntegerA 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.

Common Properties

Community Additions

ADD
Show:
© 2016 Microsoft