For Each loop container question

Question

Hello

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?

Thanks

Answer 1

What kind of issues are you talking about?

Data issues?

Format issues?

Answer 2

Yes you can,

look for this:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/0065b5c2-f633-4cbf-81f9-031d1ed25555/#a325e553-c350-4920-b477-70bd3dc278cf

Zdenek

---

Please mark as helpful and propose as answer if you find this as correct!!! nosekz.eu

Answer 3

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

Answer 4

That worked..I even tried putting 10 - maximumerrorcount for for each loop container. And it also worked....

Thanks

Answer 5

Thanks Sarat

I tried but it didnt work for me...But i tried putting Maximum Error count as 10 or 1000, and it works fine.

Thanks