Thank you for the reply..

Basically i have Header and DetailRow table seperalty.So need to transfer H row to header table and D row to DetailRow.

Can i acheve this without scriptask?

I have one table for header which will store the header date,detail table to store the actual data and trailer can be moved to text file or table.I will count the detail records and store the count in variable using rowcounnt tranformation and later i need to match this count with trailer row count ie.4

H,2011-06-02

D,value1,value2,value3,1

D,value1,value2,value3,2

D,value1,value2,value3,3

D,value1,value2,value3,4

T,4, 10