'Is there a way to make an Homologation between many files on Integration Services?

I'm developing an Integration Services Project [on Visual Studio 2019].

Main reason of developing it, is to create a process of homologation in which 2 files takes action. I call these files as MAIN FILES (this files are already on disk) and DUMMY FILES. Output of this homologation process must be the same quantity of MAIN FILES but with a new column that comes from DUMMY FILE. Example, if there comes 3 MAIN FILES with 2 DUMMY FILES, output must be those 3 MAIN FILES with new columns.

So, when Integration Service is executed, it'll run an application .EXE which creates some directories and download some DUMMY FILES. Quantity of CSV downloaded can be 0 or more files.

Afterwards, it executes a Script Task, based on status of previous .EXE app, it returns Success or Fail depending of the execution status (Script Task read a ".info" file). I've created an Object variable and here (on Script Task) I was setting the value of it to an Array of strings that stores the locations of those DUMMY FILES AND MAIN FILES.

Now, I need to take each MAIN FILE and do the homologation process via Data Flow Task with each DUMMY FILE. I was trying to do a nested foreach loop but I don't how to output the same quantity of MAIN FILES.

This is my flow, I've tried using a nested FOREACH Loop



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source