I have an SSIS package where I am processing some files in a ForEach loop. In the loop I have a data flow task which does the processing. I have made sure that the loop doesn't stop even if there is bad file by setting the maxerror count of the loop to '0'. I tried to catch the error in a message box using the script task on 'ON ERROR' Event handler of the loop container. Instead of getting one error , I get three. 'Popagate' is set to false on the data flow’s OnPostExecute event. Please help.
Main package - Loop Task - Data Flow Task