-
Double-click tParseRecordSet to open its
Basic settings view.
-
From the Prev. Comp. Column list
drop-down list, select the column that holds the personal information to be
parsed. In this example, it is person.
-
Click the [...] button next to Edit schema to open the schema editor.
Click the [+] button in the right panel
to add four columns: id and age of the integer type, and name and sex
of the string type.
Click OK to close the schema editor and
accept the propagation prompted by the pop-up dialog box.
-
In the Attribute table area, fill in each
Value column with the corresponding
column name in the MS SQL Server table that holds the personal
information.
Click the [+] button in the right panel to add four columns: id and age of the integer type, and name and sex of the string type.Click OK to close the schema editor and accept the propagation prompted by the pop-up dialog box.