Receiving VS_ISBROKEN when trying to import multiple Excel files using foreach enumerator

Cynthia McMahon 46 Reputation points

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.


User's image

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
515 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,074 questions
{count} votes