Receiving VS_ISBROKEN when trying to import multiple Excel files using foreach enumerator
I've developed a package that iterates over a folder and imports Excel file, at least that is what it is supposed to do. Every so often, It will reach a file and give the error message below. If I go into the connection manager and select the file that failed, it works correctly. I've tried setting things to run in 32-bit instead of 64-bit. I've tried setting the connection manager to use delay validation. Neither approach worked. There is nothing wrong with the file, because if I just manually update the connection string it works fine. I'm at a loss as to what to look at now.
Thanks!