SSIS Error:The GetEnumerator method of the ForEach Enumerator has failed
Problem Statement: SSIS package failing with below error.
Error: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80004005 "Unspecified error". This occurs when the ForEach Enumerator cannot enumerate.
Requirement : Using ForEachLoop ,import data from multiple excel and each excel will have one or more sheets with different sheet names. Hence need to automate this using FOREACHLOOP functionality.
Steps :
1) First/external FOREACHLOOP will loop multiple excels using variables.
2) Second/Internal FOREACHLOPP will loop or pick sheet name for different excels.
3) Second/Internal FOREACHLOPP will have “Foreach ADO.net schema rowset enumerator” and excel file path give as source file.
I understand error is because enumerator not able to find the file .But why so I am not able to find. Though connection manager has proper excel path and foreachloop for excel loop alone works fine.
Not sure how to solve this error. Need some help.
ssis-2012
asked Nov 20 at 9:50
Nischey Anand
7911
add a comment |
Problem Statement: SSIS package failing with below error.
Error: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80004005 "Unspecified error". This occurs when the ForEach Enumerator cannot enumerate.
Requirement : Using ForEachLoop ,import data from multiple excel and each excel will have one or more sheets with different sheet names. Hence need to automate this using FOREACHLOOP functionality.
Steps :
1) First/external FOREACHLOOP will loop multiple excels using variables.
2) Second/Internal FOREACHLOPP will loop or pick sheet name for different excels.
3) Second/Internal FOREACHLOPP will have “Foreach ADO.net schema rowset enumerator” and excel file path give as source file.
I understand error is because enumerator not able to find the file .But why so I am not able to find. Though connection manager has proper excel path and foreachloop for excel loop alone works fine.
Not sure how to solve this error. Need some help.
ssis-2012
asked Nov 20 at 9:50
Nischey Anand
7911
add a comment |
Problem Statement: SSIS package failing with below error.
Error: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80004005 "Unspecified error". This occurs when the ForEach Enumerator cannot enumerate.
Requirement : Using ForEachLoop ,import data from multiple excel and each excel will have one or more sheets with different sheet names. Hence need to automate this using FOREACHLOOP functionality.
Steps :
1) First/external FOREACHLOOP will loop multiple excels using variables.
2) Second/Internal FOREACHLOPP will loop or pick sheet name for different excels.
3) Second/Internal FOREACHLOPP will have “Foreach ADO.net schema rowset enumerator” and excel file path give as source file.
I understand error is because enumerator not able to find the file .But why so I am not able to find. Though connection manager has proper excel path and foreachloop for excel loop alone works fine.
Not sure how to solve this error. Need some help.
ssis-2012
asked Nov 20 at 9:50
Nischey Anand
7911
Problem Statement: SSIS package failing with below error.
Error: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80004005 "Unspecified error". This occurs when the ForEach Enumerator cannot enumerate.
Requirement : Using ForEachLoop ,import data from multiple excel and each excel will have one or more sheets with different sheet names. Hence need to automate this using FOREACHLOOP functionality.
Steps :
1) First/external FOREACHLOOP will loop multiple excels using variables.
2) Second/Internal FOREACHLOPP will loop or pick sheet name for different excels.
3) Second/Internal FOREACHLOPP will have “Foreach ADO.net schema rowset enumerator” and excel file path give as source file.
I understand error is because enumerator not able to find the file .But why so I am not able to find. Though connection manager has proper excel path and foreachloop for excel loop alone works fine.
Not sure how to solve this error. Need some help.
ssis-2012
ssis-2012
asked Nov 20 at 9:50
Nischey Anand
7911
asked Nov 20 at 9:50
Nischey Anand
7911
asked Nov 20 at 9:50
Nischey Anand
7911
asked Nov 20 at 9:50
Nischey Anand
7911
asked Nov 20 at 9:50
Nischey Anand
7911
7911
add a comment |
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53390278%2fssis-errorthe-getenumerator-method-of-the-foreach-enumerator-has-failed%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53390278%2fssis-errorthe-getenumerator-method-of-the-foreach-enumerator-has-failed%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
