ssis package to sort file which has header record, actual records, trailer record
$10-30 USD
Selesai
Dibuat lebih dari 5 tahun yang lalu
$10-30 USD
Dibayar ketika dikirim
hello
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])
H1020XXXXXXXXXX
509090909092343
132423423432434
343242342342343
T12295834958
sample output file([login to view URL]) similar to below:
H1020XXXXXXXXXX
132423423432434
343242342342343
509090909092343
T12295834958
"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)
Thanks