Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saadat82
Starting Member
1 Post |
 Posted - 2012-12-17 : 04:36:07
|
| I have a scenario where i need to synchronize two tables in SSIS Table A is in DATABASE A and TABLE B is in DATABASE B. Both tables have same schema. I need to have a SSIS package that Synchronize TABLE A with TABLE B in Such a way That 1. It inserts all the records That Exist in Table A into Table B AND 2. Update TABLE B if Same "Key" exsit in Both but Updated records in Table A For Example Table A and B both Contains Key = 123 both Few Columns in Table A has been Updated. I am thinking about using Merge Joins but that helps with only insertion of New records. How i can manage to implement UPDATE thing as well |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-17 : 13:52:50
|
| How about Trigger? |
 |
|
|
|
|
|
Synchronization of two tables in SSIS