[Solved] SSIS insert at the same time 3 entries

by


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.

solved SSIS insert at the same time 3 entries