Scenario 15: There is a source table and 3 destination table T1,T2, T3. How to insert first 1 to 10 record in T1, records from 11 to 20 in T2 and 21 to 30 in T3.Then again from 31 to 40 into T1, 41 to 50 in T2 and 51 to 60 in T3 and so on i.e in cyclic order. How to achieve this in SSIS in various ways....(inlcuding any SQL quries)......? Thanks and Regards, Desparado.

add a row number to data stream. this is a sample of add row number to data stream: http://support.microsoft.com/kb/908460 then use conditional split with an expression to check row numbers and redirect to desired output.http://www.rad.pasfu.com