asked
SSIS for each loop container error handling
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.
Thanks for giving me reply Pavel, I will try to post the comment ASAP
Hi pavel, I think still the problem contains the same.The error files inside the Dtat flow task which is flowing to file system task is getting stopped .
Hi Pavel , It is working fine thank you for your help. Thanks of your concern on me you helped me a lot in one of the application development.
