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

Cynthia McMahon 46 Reputation points
2023-05-24T15:42:47.5733333+00:00

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!

User's image

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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.