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

Screenshot 2019-06-21 at 8.38.05 AM

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.

Screenshot 2019-06-21 at 8.49.27 AM

tMap is used to Map the columns from input file to config file.

Screenshot 2019-06-21 at 11.46.13 AM

Output file will always be overwritten. So please uncheck

  1. append
  2. Throw an error if the file exists

Screenshot 2019-06-21 at 11.48.59 AM

 

Next is Unpivot 

Dynamic Schema Main       Manage Order          Load data