CODEWITHSUNDEEP
sql-serverexcelssisoledbetl
Kudos
Kudos

Reputation: 1154

SSIS: Multiple Sources to 1 Destination

I am quite new to SSIS. I have multiple sources for example i have products in sql database and excel sheet and i need to migrate them both to 1 destination and that is another sql database. I have found some answers but they are the other way around 1 data source and multiple destinations but i can't seem to find my answer. At the bottom you can see how i am trying to do it right now. I hope someone can point me to right direction.

enter image description here

Upvotes: 2

Views: 6286

Answers (1)

Hadi
Hadi

Reputation: 37313

There are 3 approaches to import data from multiple source into on destination table:

(1) Run in parallel

It is similar to the way you are achieving, but you may have to uncheck the table lock option from both destination which decrease performance.

(2) Union All transformation

In the data flow task add both sources then add a UNION ALL transformation to merge both sources into one flow, then map the output to the destination

(3) Two consecutive data flows

Add 2 data flow tasks in the package, on each data flow import one source to the destination. And map one data flow to the other using a precedence constraint. In this way, data is imported in 2 phases (each source in one phase)

Upvotes: 4

Related Questions