SQL Server >

SQL Server Forums >

SQL Server Integration Services >

For Each loop container question

For Each loop container question

Thursday, December 06, 2012 10:11 PM

0

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
- Reply
- Quote

All Replies

Thursday, December 06, 2012 11:32 PM

0

What kind of issues are you talking about?

Data issues?

Format issues?
- Reply
- Quote
Friday, December 07, 2012 1:01 AM

0
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
- Marked As Answer by Swetha Monpara Friday, December 07, 2012 3:22 PM
- Reply
- Quote
Friday, December 07, 2012 4:49 AM

0

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
- Reply
- Quote
Friday, December 07, 2012 5:12 PM

0

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

Thanks
- Reply
- Quote
Friday, December 07, 2012 5:14 PM

0

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
- Reply
- Quote

Frequently asked questions - Forums help