You are here:

Text Wizard Step 3

Use this Step to define the file you selected in Text Wizard Step 2 as a table. The top of the dialog box shows the properties of the file that is being defined and the bottom shows the table properties, including Table Name and Column Properties.

Column properties in the bottom of the dialog box are shown for the currently selected column header. Available properties depend on whether the file type you specified was comma, tab, fixed, or stream. See the table below for properties definitions.

If you specified character separated, then the table data is shown parsed according to the separator character. You can specify field names, types, lengths, etc., but you cannot change the column separators.
If you specified a fixed-length file type, you can use your mouse to specify field breaks in the sample data control. You can also specify field names, types, lengths, etc.
- Dragging a column separator to the left increases the column on the right side of the separator, and shrinks and eventually removes columns to the left.
- Dragging a column separator to the right increases the column on the left side of the separator, and shrinks and eventually removes columns to the right.

Field	Definition
File Properties
File Name	File name of the data source
Type	Type of text file: comma, tab, fixed, or stream.
Delimiter Character	Character used as a delimiter in character-separated files. It can be any printable character. The default is a comma (,).
Decimal Symbol	The decimal separator is a comma or a period used when data is stored. The international decimal symbol (.) must be used in DML statements and parameter buffers.
Column Names in First Line	Select this check box to indicate that column names are specified in the first line of the file. Note: The Default Type, Delimiter Character, and Column Names in First Line settings apply only to tables not previously defined. These fields also determine the attributes of new tables created with the Create Table statement.
Table Attributes
Table Name	Name of the selected table containing your source or target data.
Name	Name of the column selected in the Column Information box.
Type	Data type of the field: Varchar, Numeric, or Date. If the field type is Date, you must enter or select a mask.
Mask	Controls the format of date time fields, such as, dd-mm-yyyy produces a date formatted as 12-25-2014. Required when field type is Date.
Precision	Numeric data types — Maximum number of digits used by the data type of the column. Character types — Length in characters of the data. Binary data types — Length in bytes of the data. Time, timestamp, and all interval data types — Number of characters in the character representation of the data.
Scale	Decimal and numeric data types — Maximum number of digits to the right of the decimal point. Approximate floating point number columns — Scale is undefined because the number of digits to the right of the decimal point is not fixed. Datetime or interval data containing a seconds component — Number of digits to the right of the decimal point in the seconds component.
Length	In a fixed-length table, the number of bytes of data.
Offset	In a fixed-length table, the number of bytes from the start of the table to the start of the field.

When you are finished, click Finish or click Back to return to Text Wizard Step 2.

The configured text data source is displayed in the Connect To Source dialog box, under the Text Files branch of ODBC Data Sources. Highlight the data source and click OK in the dialog box to begin configuring your Source or Target.