Can't use more than 64 excel files in foreach enumerator - by Guilherme Schmidt

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 787265 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 5/20/2013 12:21:42 PM
Access Restriction Public


I'm trying to load multiple excel files and multiple sheets.

I did it, but when it reachs 65º file, i got this error:

Error: 0xC0014023 at Foreach Loop Container: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80004005 "Unspecified Error". This occurs when the ForEach Enumerator cannot enumerate.

Until 64º file, all works fine.

When I tried with only 64 files in a folder and I didn't get error.
Sign in to post a comment.
Posted by Microsoft on 6/1/2016 at 7:48 PM
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SSIS. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available.

If the issue is a critical business interruption, please call CSS (Customer Support Services).

Thanks again for reporting the product issue and continued support in improving our product.
Posted by Microsoft on 5/22/2013 at 5:08 PM
Hello Guilherme. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (