0

I need to merge a table say table1 located on server1 to table1 (same table) located on server2.

Actually I am asked to do this via ssis package

user7540144
  • 1
  • 1
  • Setting up a linked server would probably make life easier. – Dan Bracuk Feb 09 '17 at 12:30
  • Thanks @DanBracuk for your answer. Actually I am new into all these can you please tell me something more In details ? – user7540144 Feb 09 '17 at 12:33
  • Your google search string is `sql server linked server`. – Dan Bracuk Feb 09 '17 at 12:34
  • For SSIS, I searched for "SSIS union multiple sources" and found [this](https://www.youtube.com/watch?v=pl7oOlXBgKU) – JohnHC Feb 09 '17 at 12:36
  • You should have two connection manager one for table 1 server and another linked server table 1.either you have to use execute sql task select * from table1 union all select * from [linkedserver].table2 – Thangadurai.B Feb 09 '17 at 12:43
  • @Thangadurai.B sir I need the package to run daily. And I am confused a bit as whenever the package would run it shouldn't load the previous data which has already been loaded Can you guide me more ? – user7540144 Feb 09 '17 at 12:44
  • 1
    @user7540144 I think you need a scd type, Refer [link](https://blogs.msdn.microsoft.com/karang/2010/09/29/slowly-changing-dimension-using-ssis/) – Thangadurai.B Feb 09 '17 at 12:56
  • I will have to study how to use SCD @Thangadurai.B thank you again! – user7540144 Feb 09 '17 at 13:07
  • Sorry to bother you @Thangadurai.B sir is SCD TYPE 1 suitable in my case ? – user7540144 Feb 09 '17 at 13:21

0 Answers0