Hi all, I am importing .txt file through Data Flow Task in For each loop container in SSIS , Now i am getting some error .txt files in the folder path and package is stopped executing. So some one kindly heip me how to skip the error file and execute the package with good .TXT files in for each loop container.
If you have a Data Flow in the For Each Loop container, then you have to set the `MaximumErrorCount` property to `0` for each component from the Data Flow up to the SSIS Package. So you have to set it for the Data Flow, For Each Loop container and also for the Package itself. Then the packake will not fail and the loop will continue with next file if one of them fails. Any way I then suggest to implement some logging of the failed files (On Error Constraint from the Data Flow) so you know what and when has failed.