I encountered this error this morning on an SSIS ETL package that had not changed, the source Excel file had not changed, and the target SQL Server table had not changed. It was failing in both production and development. The only thing that HAD changed was that we upgraded the SQL Server environments to SP3. I suspect that this had somehow disturbed the metadata.

I opened the package in development, opened and saved every step, and then ran it. It worked fine. I then deployed the refreshed package. If failed until I opened (didn’t change) and closed the ODBC environment variable. Then it worked in production.

Good luck!