As data lakes have been maturing and we're starting to see best practices emerge, one of those practices I've seen is the concept of early ingestion and late processing.  So...

I subscribe to the idea of using zones in a data lake, and having a "raw zone" that is immutable.  The data in other zones should be replaceable by rerunning...

The first two things I thought to try were to set "DelayValidation=True" for the Data Flow and "ValidateExternalMetadata=False" for the Excel Source component; but neither seemed to help for me.

I don't know if this is useful info, but to recreate I do the following:

1-Create new SSIS package

2-Add Data Flow

3-Add Excel Source component

4-Double click Excel Source to open

5-From Excel Source...

I checked my registry and see that the value for HKEY_LOCAL_MACHINE ? Software ? Wow6432Node ? Microsoft ? Office ? 12.0 ? Access Connectivity Engine ? Engines ? Excel ?...

Thank you for the idea, I wasn't familiar with using other sources to extract data from Excel. That is a very useful idea, especially if you only need to...