I am using SQL Server Integration Services (SSIS) with SQL Server Data Tools (graphical component for Visual Studio 2015).
Within my processing package (SSIS) I have streams that, depending on the defined condition, the respective Data Flow Task is triggered.
Each Data Flow Task has basically a Flat File Source using ADO.Net Source and a Script Component, where I do the treatments using the C # language.
Processing is in Loop, and basically does the following:
If it is file 1, go to Data Flow Task 1 (see image below);
Ifitisfile2,gotoDataFlowTask2(seeimagebelow); 
Inallcasestheyshouldbeinsertedinthesametable,butwithdifferenttreatmentsduetothebusinessrule.
However,it'swhereI'mintrouble.Noflowerror,betterdescribing.
Incase1,thedataisenteredcorrectlyaftervalidatingallrules(seeimagebelow); 
Incase2,thedatanotenteredintothedatabase,evenaftervalidatingtherules(seeimagebelow) 
An important addendum: If I delete or disable the first Data Flow Task, and have the package run again the second Data Flow Task (the second task) processes normally.
I already checked the encoding and there are no errors, I created everything from scratch again, but nothing worked; I tried to find some cache or reference that was wrong, but nothing was detected wrong.
So, does anyone after understanding this whole process know how to tell me what's going on?
Thank you for your attention.