I am try to load multiple excel files into database, I have tried this link:
How to loop through Excel files and load them into a database using SSIS package?
but it keeps looping through the files and never ends.
can anyone help?
Asked
Active
Viewed 485 times
1 Answers
0
This is not likely given you have a small number of files which you should when testing. You need to log the file names inside the ForLoop and see if the values are ever changing. With the dynamic sheet name may have a stability problem, e.g. some characters may not be able to be picked up by the OLEDB driver. This is in general a not recommended practice to process dynamic data.
Arthur
- 1,441
- 1
- 13
- 17
-
I can loop through the files successfully, but when I add the second Foreach Loop, the loop keeps running. What is your recommended method for dynamic sheet name?. I know there are some shell and C# scripting, but my scripting skills are not very good. – Sazan Abdalrhman May 23 '17 at 07:01
-
So do you think the solution in that link is wrong? – Sazan Abdalrhman May 23 '17 at 23:51
-
Check the mappings @SazanAbdalrhman they claim it does but I an skeptical. – Arthur May 24 '17 at 20:27
-
the mapping in the first ForeachLoop is working, it looks like the second mapping is not working, is that what you mean? – Sazan Abdalrhman May 30 '17 at 05:16
-
Yes, please log the values set at run time – Arthur Jun 05 '17 at 03:21