sqlagent007
asked on
SSIS foreach loop not working to enumerate xls sheets
I have a package that collects .xls files from a directory (path set by variable). Once the file has been picked up, I try to enumerate the sheets in the file, since there can be 1 or more sheets depending on the file. Once the ForEach loop container tries to enumerate the sheets in the file, I get the following error: Error:
0xC0014023 at Foreach Sheet: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80131509 "(null)". This occurs when the ForEach Enumerator cannot enumerate.
The funny thing is this exact package worked on a different computer. I am not sure where to go from here.....Any help would be appreciated.
ssis-package-ss.JPG
0xC0014023 at Foreach Sheet: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80131509 "(null)". This occurs when the ForEach Enumerator cannot enumerate.
The funny thing is this exact package worked on a different computer. I am not sure where to go from here.....Any help would be appreciated.
ssis-package-ss.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, it was a driver issue.
please put a debug point in script task and trace exception.
Thanks,
Nishant