Foreach loop stop after processing 1 file

Hi, With Windows 2008 and SQL 2012, migrated a SSIS from 2005 to 2012. ForEachLoop process all files fine in 2005; but stop after processing first file. I followed few site suggestions and changed FastLoadMaxInsertCommitSize to 2147483647 or 1000000, but issue still exists. Did I missed anything? Thanks. Chris

10 |1200

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

sqlaj 1 commented · Dec 08, 2013 at 04:06 PM

Are there errors? Have you put any type of error trapping in place to capture errors? The more information you provide the better others can assist.

2 ·

Chris 2 commented · Dec 09, 2013 at 04:47 PM

Hi, Thanks for the replying. No, there was no error; it just processed one file. Beside change Maximum insert commit size option to 2147483647, I followed this site: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/0065b5c2-f633-4cbf-81f9-031d1ed25555/how-to-skip-wrong-excel-files-ignore-errors-on-ssis-foreach-task 1. set MaximumErrorCount to high value on ForeachContainer 2. set FailPAckageONFailure to true on each task in workflow 3. set ForceExecutionResult to Success on DataFlow 4. set ForceExecutionResult to Success on Package It worked. Thanks again. Chris

0 ·

question