June 24, 2010 at 10:46 am
SSIS package containing for each loop which is use to loop of each excel file in given path.
Sometimes the package not looping over all files.
Any known issue?
June 24, 2010 at 4:44 pm
Hi ya
guess you have checked all the settings in the package and have you tried to test run package with few files in the folder and see if that happens again
Cheers
Vani
June 25, 2010 at 6:06 am
Can you give more configuration details? What have you done so far?
In a for each loop, you can specify which types of files the loop has to pick up. Maybe something went wrong there?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 25, 2010 at 8:45 am
[font="Comic Sans MS"]
Questions:
1) Does the SSIS package fails? Or just skip loading few files?
2) If they SSIS package doesn't pick few files (without failure) - what happens when you restart the package? Do they get processed by the package?
In my current project I am using around 70+ SSIS packages that use forEachLoop to loop over csv files and never faced this issue.
Make sure that filename format is proper for the filenames which it's not taking. Also - if the file is dropped into the folder location after forEachLoop started executing and evaluated the list - it won't pick up the new files. But they will be picked up in next run (2)
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply