Hello I have 2 SQL tables that have the same nomenclature on 2 different server, my need isto synchronize the 2 tables in the knowledge that I have operation UPDATE, DELETE,and INSERT can be performed on this table. I have no real time constraint. The 2 tables are in SQL2008 I envisage a solution with SSIS. Thank you in advance for your answers.

Please see if this post is the right answer: Tables Synchronization http://www.sqlis.com/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspxArthur My Blog

sorry, but this article addresses the problem of adding data but not update or delete thedata from the destination table, thank you for your reply

Well, I can see a lot of questions coming in asking help in synchronizing two tables. I 've done that using Execute SQL Task running a merge statement. As mentioned here: http://www.kimballgroup.com/html/08dt/KU107_UsingSQL_MERGESlowlyChangingDimension.pdf There is also an interesting post here http://blogs.msdn.com/b/jorgepc/archive/2010/12/09/synchronize-two-tables-using-sql-server-integration-services-ssis-part-ii-of-ii.aspx so please let us know if the aforesaid helps.Arthur My Blog

The first article describes the method MERGE ,but it will load the data into a temporary table to use this method, the second section is the same as your first response, it treats the problem of adding only.

Sort, Merge Join, Conditional Split is another technique: http://blogs.msdn.com/b/jorgepc/archive/2010/12/07/synchronize-two-tables-using-sql-server-integration-services-ssis-part-i-of-ii.aspxArthur My Blog

Hello Ultimately, I used server functionality associated with a join without creating the sametable on the destination server. Thank you for your response; Cdt