TH*4.2*876545*P~~IO*3456*color~ n

my data would be like this

table1

id t1 t1 t3 i1

TH 4.2 876545 p 3456

table2

id i1 i2

iO 3456 color

i need to do it using ssis

here,i1 is primary key of table2 , which is foreign key of table1

thanks