Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

SQL Destination Editor (Advanced Page)

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.

Note 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.

Note 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.

Note 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.