In this section we will use the Limit property of tInputFileDelimited component and fetch only the column headers. then will load this into a file
Set up of input file is as below. The key point to note here is the Limit option. You have to set it to 1 to fetch only the header records.
tMap is used to Map the columns from input file to config file.
Output file will always be overwritten. So please uncheck
- Throw an error if the file exists
Next is Unpivot