question

vidyasagar avatar image
vidyasagar 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.
sql-server-2005ssisdatawarehouseforeach-loop
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
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.
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks for giving me reply Pavel, I will try to post the comment ASAP
0 Likes 0 ·
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 .
0 Likes 0 ·
What error you are receiving when the package fails?
0 Likes 0 ·
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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.