Data from Multiple Data sources into Single Destination

• Pulivarthi Sasidhar

  SSCertifiable

  Points: 6706

  More actions

  December 10, 2010 at 3:10 am

  #144015

  Hi All,

  I have one requirement.

  I have 4 OLEDB Datasources , The data from which needs to be inserted into my another Single OLEDB Destination .

  Need to insert data in the following way.

  Datasource1 - Destination1 of Table1

  Datasource2- Destination1 of Table2

  Datasource3 - Destination1 of Table3

  Datasource4 - Destination1 of Table4

  Datasources are of Different servers and Destination is local Server.

  I did it by one DataflowTask contains 4 OLEDB Sources and 4 OLEDB Destinations [1-1]

  Datasource1 - Destination1 of Table1

  Datasource2- Destination2 of Table2

  Datasource3 - Destination3 of Table3

  Datasource4 - Destination4 of Table4

  Required one:-

  I need [4-1] ,multiple servers data into different tables of local server by using single OLEDB Destination.

  How to import data from 4 servers to my local server Database.

  My local server DB has 4 tables for 4 server's Data

  Thanks,

  Sasidhar P

• Phil Parkin

  SSC Guru

  Points: 246956

  More actions

  December 10, 2010 at 3:12 am

  #1260941

  And what is your question?

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  December 10, 2010 at 3:59 am

  #1260958

  Phil Parkin (12/10/2010)

  ---

  And what is your question?

  4 data sources each having it's respective destination

  OR

  as Phil said...

  Raunak J

• Evil Kraig F

  SSC Guru

  Points: 100851

  More actions

  December 10, 2010 at 11:21 am

  #1261152

  Pulivarthi Sasidhar (12/10/2010)

  ---

  How to import data from 4 servers to my local server Database.

  My local server DB has 4 tables for 4 server's Data

  Use four data flows, or use the same data flow with four source/destinations in it since they're separate tables. You can re-use the destination and tell it which table to aim at.

  I think that's the question

  ---

  - Craig Farrell

  Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

  For better assistance in answering your questions[/url] | Forum Netiquette
  For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
  Twitter: @AnyWayDBA