Post reply

how to send equal data in two destination tables

  • September 19, 2011 at 9:40 pm

    #243417

    hi friends source data comes like id,name,sal

    1,a,1000

    3,b,2000

    7,c,3000

    2,d,4000

    6,e,9000

    9,f,10000

    in source comes records 6 records how to send in two tables equal records that means first table should be send three records and second table should be send three records how to solve in ssis plz solve this problem

  • September 20, 2011 at 12:27 pm

    #1384083

    If you have an incremental identity column in your data, you could calculate the median. Then use the conditional split transformation. If the Id column is less than or equal the medican, go to the first table otherwise send the record to the second table.

    HTH,

    Rob

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

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