i need help in writing SSIS package without sorting header record and trailer record.
only actual data should be sorted on 1st column which has length 1 character.
sample Input File([login to view URL])
sample output file([login to view URL]) similar to below:
"header record starts with "H"
Trailer records starts wtih "T"
resultant file should have "Header record as first record, trailer record as last record".
only actual data should be sorted ( please see sample output)