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.
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
- Click OK to close the dialog box.