Excel File 0xC020801c issue

I encountered a couple of issue with :-

a) DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER - Excel Source Failed validation and return error code  0xC020801c.

b) Microsoft.Jet.OLEDB.4.0 is not registered. If the driver is not installed, run package in 32bit mode. An OLEDB Service componet :- 0x80040154 description - Class not registered.

This really points to 32 bit vs 64 bit incompatibility issues.


Install 64 bit driver or redeploy your SSIS package in 32 bit.


Popular posts from this blog

Solving Sonarqube :- Project was never analyzed. A regular analysis is required before a branch analysis

spark - pyspark reading from excel files