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.

Solution:

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





Comments

Popular posts from this blog

A quick tutorial for OWASP ZAP tool for beginners

ionic2 cordova build android - Unable resolve gradle 2.2.3