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

Status : 


Sign in
to vote
ID 787265 Comments
Status Active 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 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 (