I have a for each file container with a Foreach ADO.NET Schema Rowset Enumerator inside.
It reads each file (and each sheet within) and writes to a SQL table.
The files have the same structure just an additional sheet each month.
The package runs fine for the first two files then on the third it loads but can't carry out the file transfer task as it says the file is being used by another process.
I manually moved this file.
I then ran the package again for the last file and got the following message:
Error: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80004005 "Unspecified error". This occurs when the ForEach Enumerator cannot enumerate.
Any ideas why this is happening? It runs fine for two files, the third it wont move and the 4th it says it cannot enumerate.