Online Documentation for SQL Manager for SQL server

Customizing bulk insert options


Use this step of the wizard to set bulk insert options. The detailed description of these options is given below.

 

Import Data - Customizing bulk insert options

 

 

CheckBox Keep nulls

This option specifies that NULL columns should retain a null value during the bulk copy operation, rather than have any default values for the columns being inserted.

 

CheckBox Fire triggers

This option specifies that any insert triggers defined on the destination table will execute during the bulk copy operation.

 

Bulk insert file name

Type in or use the btnSaveAs button to specify the name and path to the bulk insert file name using the Save As... dialog. If data_file is a remotely stored file, specify the Universal Naming Convention (UNC) name.

 

Bulk insert field terminator

Specify the field terminator to be used for char and varchar data types.

 

 

When you are done, click the Next button to proceed to the Customizing common options step of the wizard.