Product Home
Text to SQL Converter Prev Page Prev Page
Product profile
Project properties
Column mapping
Execution

Source and Target File, Table and Properties

This page helps you to setup most importatnt project propertie. They are:

  • Source file name. This text file must contain source data. You must have read permission for the file.
  • File format: delimited or fixed width.
  • Columns separator for delimited file format. You can select it from drop-down list or enter manually.
  • Target file name. You must have create and write permissions for the file.
  • Table name. The progtam will generate INSERT statements fpr specified table.
  • Optional SQL statement sepatator. The program can add something like 'GO' or ';' after each statement.
  • Transaction size. The program can write 'COMMIT' statement after blocks of INSERTs. You can specify transaction size.