Merge records in a sorted order in SSIS.

  • 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

    T1a 3678

    T1b 3678

    T1e 3678

    TH 2455 2

    T1c 2445

    T2d 2445

    TH 4522 3

    T2d 4522

    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!

  • Learner093 (5/3/2013)


    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

    T1a 3678

    T1b 3678

    T1e 3678

    TH 2455 2

    T1c 2445

    T2d 2445

    TH 4522 3

    T2d 4522

    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!

    You haven't asked a question, so how can we help?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply