question

Chris 2 avatar image
Chris 2 asked

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
ssissql-server-2012
2 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.

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 Likes 2 ·
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 Likes 0 ·

0 Answers

·

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.