Thursday, December 06, 2012 10:11 PM
I have multiple files in folder which gets processed using For each loop container. In case one or two files have some issues, For each loop container should still get execute successully leaving the files which had issues.
Can I do this in SSIS?
Thursday, December 06, 2012 11:32 PM
What kind of issues are you talking about?
Friday, December 07, 2012 1:01 AM
Yes you can,
look for this:
Please mark as helpful and propose as answer if you find this as correct!!! nosekz.eu
- Marked As Answer by Swetha Monpara Friday, December 07, 2012 3:22 PM
Friday, December 07, 2012 4:49 AM
You can ignore the error if it occurs. Go to the properties and make FailPackageOnFailure as FALSE and give a maximum error count as below and here you go..
sarat chandra sahoo
Friday, December 07, 2012 5:12 PM
That worked..I even tried putting 10 - maximumerrorcount for for each loop container. And it also worked....
Friday, December 07, 2012 5:14 PM
I tried but it didnt work for me...But i tried putting Maximum Error count as 10 or 1000, and it works fine.