sql server - SSIS insert at the same time 3 entries

Question

Hello so in my SSIS data flow and I have 3 flat files which need to be put in 1 table (ole db). I need to insert them at the same time and on the same row. How to do this ?

3 entries for 1 destination but I need to insert them at the same time on the same row:

Answer 1

So you have Col1 in File1, Col2 in File2 and Col3 in File3 and you need to import them all Col1, Col2, Col3 into one table. You are correct, you need to use Merge Join which needs a column to join on. You do need to do some intermediate steps, there's no direct way to do that AFAIK. I can see two options:

1. Create on-the-fly row_number column for each source and then do merge join. Use this for script component.
2. Create temporary tables with Auto incrementing Identity column for each of the sources which you can then do merge join with.