I have created a SSIS package using For Each Loop with Excel as source and DB as destination.
Many of these files are exported to this directory.
The strange part is that there is nothing wrong with the package but only excel files.
What i meant is only those file that i opened physically like file 1 to 10 and just hit CTRL S to save and execute the package, the import would stop at file 10. So, if i want the package to process let say file 11 to 20, i would need to open file 11 to 20 first and save and then execute the package, it would go on to process file 1 to 20 only.
It was exported from a click of button "Export To Excel" of a web site. User would then prompted To Open, Save or Save As. They choose Save As so that it would be saved to the destinated directory. I guess this maybe the cause of the problem. Thanks a lot