BI Studio provides advanced XML, CSV and bulk SQL import features.
The Bulk SQL Import can import or execute SQL commands (or statements) in an SQL file. Bulk SQL Import feature is a good fit for large SQL files and imports. You can import any large SQL file into your database and a progress dialog will be shown. During SQL import all log status and information will be written in a log file. After the import the user can check and find more information about bulk import.
Bulk SQL Import Dialog
The log file will be written to the desktop but the user can change the file location.
Data import feature supports only CSV format. With this feature you can import any CSV data into a database table.
CSV Data Import Dialog
Field Encloser : Encloser character for the field or table column.
Field Separator: Separator character for the field or table column.
Comment: start character for the comment line
Encoding: Encoding of the CSV file.
Number of Error Limit: This option allows the user to control your CSV data import process in case of errors.
Log File: The CSV import feature writes all import errors and import summary into the log file. You can check this file after the import.