Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Insert value from one table to another (with diferent structure) Expand / Collapse
Author
Message
Posted Friday, May 2, 2014 5:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 11:24 AM
Points: 5, Visits: 57
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?
Post #1567198
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse