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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Synchronization of two tables in SSIS

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?
Go to Top of Page
   

- Advertisement -