TechNet
Export (0) Print
Expand All

SQL Destination Editor (Advanced Page)

 

Applies To: SQL Server 2016

Use the Advanced page of the SQL Destination Editor dialog box to specify advanced bulk insert options.

To learn more about the SQL Server destination, see SQL Server Destination.

Keep identity
Specify whether the task should insert values into identity columns. The default value of this property is False.

Keep nulls
Specify whether the task should keep null values. The default value of this property is False.

Table lock
Specify whether the table is locked when the data is loaded. The default value of this property is True.

Check constraints
Specify whether the task should check constraints. The default value of this property is True.

Fire triggers
Specify whether the bulk insert should fire triggers on tables. The default value of this property is False.

First Row
Specify the first row to insert. The default value of this property is -1, indicating that no value has been assigned.

System_CAPS_ICON_note.jpg Note


Clear the text box in the SQL Destination Editor to indicate that you do not want to assign a value for this property. Use -1 in the Properties window, the Advanced Editor, and the object model.

Last Row
Specify the last row to insert. The default value of this property is -1, indicating that no value has been assigned.

System_CAPS_ICON_note.jpg Note


Clear the text box in the SQL Destination Editor to indicate that you do not want to assign a value for this property. Use -1 in the Properties window, the Advanced Editor, and the object model.

Maximum number of errors
Specify the number of errors that can occur before the bulk insert stops. The default value of this property is –1, indicating that no value has been assigned.

System_CAPS_ICON_note.jpg Note


Clear the text box in the SQL Destination Editor to indicate that you do not want to assign a value for this property. Use -1 in the Properties window, the Advanced Editor, and the object model.

Timeout
Specify the number of seconds to wait before the bulk insert stops because of a time-out.

Order columns
Type the names of the sort columns. Each column can be sorted in ascending or descending order. If you use multiple sort columns, delimit the list with commas.

Integration Services Error and Message Reference
SQL Destination Editor (Connection Manager Page)
SQL Destination Editor (Mappings Page)
Bulk Load Data by Using the SQL Server Destination

Community Additions

ADD
Show:
© 2016 Microsoft