Merging 3 tables into one using SSIS

[nubianwarrior]

I am currently trying to merge three tables into a single table using SSIS. I can merge two but adding the third table is whats giving me problems. Has anyone performed this task before. If so any help would be appreciated.

 

[MDXer]

you can only merge 2 tables per task. So to merge 3 tables you Merge 2 then take the output of your first merge and use it as one of the inputs of your second merge. Be very careful of your sort orders to make sure that the correct columns are being joined on.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[nubianwarrior]

What if the tables dont have any common column on which to join the tables. Basically having 3 tables that dont have any fk relationships between them.

 

[MDXer]

then how would you ever expect to join them?

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[nubianwarrior]

those were my thoughts.....but just needed someone in my amen corner.

Thanks