Insert value from one table to another (with diferent structure)

• rsoria.03

  SSC Enthusiast

  Points: 151

  More actions

  May 2, 2014 at 5:59 pm

  #148534

  Hello everybody. As you can read in the subject, I need some help to solve a problem when I synchronize multiple tables.

  I have a Data Flow Task which contains a similar structure to this:

  http://subefotos.com/ver/?0486e544410bdfb07703c30b094c504fo.png

  I want to pass the column data (on update) for a specific register to the Table C, but Table C hasn't the same structure as Table A or B.

  It is possible on update statement, in "OLE DB Command" component, relate the columns to complete the update statement? or there's another way to do it?