We will use the tFileInputDelimited
component to read the file customers.csv for the input
data. This component can be found in the File/Input
group of the Palette.
Procedure
-
Drop a tFileInputDelimited component onto
the design workspace, and double-click the to open the Basic settings view to set its properties.
-
Click the three-dot button next to the File
name/Stream field to browse to the path of the input data
file. You can also type in the path of the input data file manually.
-
Click Edit schema to open a dialog box to
configure the file structure of the input file.
-
Click the plus button to add six columns and set the Type and columns names to what we listed in the
following:
-
Click OK to close the dialog box.