two source columns to single destination

• ahmed7.bi

  Say Hey Kid

  Points: 713

  More actions

  December 3, 2010 at 2:58 am

  #231889

  Hi

  i have table tab1 with columns a,b,c and table tab2 with columns x,y,z now i have to load the data into tab3 with columns a,b,x,y

  so i have created two oledb sources (tab1 & tab2) and a oledb desitination(tab3) now which transformation should i use to get two columns(a,b) form tab1 and two columns(x,y) from tab2 and load into destination table tab3(a,b,x,y)

  please let me know how to achieve this

• December 3, 2010 at 5:40 am

  This was removed by the editor as SPAM