I have a set of record types saying TH as Header and T1a, T1b, T1c, T1d, T1e, T2a, T2b, T2c, T2d, T2e as other type of records. TH table has a SortKey column with values 1, 2, 3, 4, 5.
All these record types are tied by a column called RecordID. The output fashion I desire is below having corresponding number of records listed under associated TH record:
RecordType RecordID SortKey
TH 3678 1
TH 2455 2
TH 4522 3
The SortKey order has to be maintained in 1, 2, 3 fashion in output file, and keeping all the record types tied by RecordID because the output file has to be read in the order of SortKey.
I am doing this all in SSIS using Merge task to have the records merged as TH ->T1a ->T1b....
Thank you for you help!