I have a package that is using a Foreach File Enumerator loop to go through a folder and pull in the data from a 3 Excel files; and insert the data inot a table in SQL Server. However, it goes through the first file, three times and inserts the row of that file 3 times in the table. But the it never goes through the other files.
I realize this may be dificult to answer without seeing it.
Does any one know what I ma be doing wrong or what I can look at.