Each file/table pair within entire data import task is treated a single independent job.
For each job you have to define file name, corresponding database table, view or synonym, file fields separator, map file input fields to table fields, logging options and import rows range.
Most of these parameters are filled with default values.
The wizard consists of four pages:
First page deals with input text files. It allows you to select import text file, choose field separator and if the first row contains column names. You can specify multiple input files by using Add button. Each file is treated as separate job and can have its own set of parameters. Preview grid allows you to preview the content of the selected file using specified field separator and first row parameters.
Second page deals with target database objects. It allows you to map each import text file to a database table, view or synonym. Each database object can be located in its own database on a different server. You have to specified server connection, database name, object type and name for each import job.
Third page allows to define mapping between file fields and table columns for each file/table pair. You can map each file input field to one or multiple columns. You can also skip file fields and table columns.
Fourth page defines the general import job parameters, such as error logging file name and mode, and range of file records to import. It allows you to resume the import job from a specified file record.