SSIS to create flat files from data in two tables -

i need create flat file data in 2 separate tables looks below

table 1:-

messageid|storeid   1        1234   2        5678 

table 2:-

messageid|productid|quantity|pickmethod   1        1111       3         z   1        0923       5         g   1        4323       1         z   2        9343       2         g   2        2334       6         z   2        2331       7         z 

in above 2 tables messageid foreignkey b/w 1 , table 2

i need create flat file looks below

0,xyz,20130303 1,1234 2,1111,3,z 2,0923,5,g 2,4323,1,z 1,5678 2,9343,2,g 2,2334,6,z 2,2331,7,z 9,10 

in above file row starting 0 header , row starting 1 storeid , rows starting 2 details particular store(productid,quantity ...)

thanks