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.