SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Synchronization of two tables in SSIS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

saadat82
Starting Member

United Kingdom
1 Posts

Posted - 12/17/2012 :  04:36:07  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 12/17/2012 :  13:52:50  Show Profile  Reply with Quote
How about Trigger?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000