I decided to move with a different approach:
I have an SSIS package with two different connections and two different file flat file sources inside the same data flow.
One connection try to read the file with RES column and the other Without the RES column
Both of the flat files sources connect to the same UNION ALL.
Issue is that if one of the sources gets an error, then the other is not able to move data after the union all
I was expecting that, if one source fails and the other sucesses (as it is occurring) then I will be able to continue. But problem is that even with datasource 2 succeding and sending 3 rows into the union all (as per the data viewer) then data is not moved from union all into the next task.
Can you help me understand how can I change this?