Online Documentation for Data Import for SQL Server
Step 9 - Setting common options
Using this step of the wizard you can set final import options.
Commit when done
Check this option to commit the transaction after all records are imported.
Commit after each ... records
These control allows you to define the number of records in each block to be supplemented with the COMMIT statement.
Rollback on error
Check this option to rollback the transaction if an error occurred.
Import all records
Specifies that all records of the source file will be imported.
Import only ... record(s)
Specifies the number of records to be imported.
Import empty rows
If this option is checked then empty records are imported.
Auto trim values
Check this function to remove all leading and trailing white-space characters from all imported records.
Save Result SQL Script to File
This option allows you to save the result SQL script of the import operation to an external *.sql file on your disk drive.
Specify the script file name and select its location using the button which calls the Save As... dialog.
Skip this step
When you are done, press the Next button to proceed to the next step.