Currently, I'm expressing an error when I'm trying to work in Excel as OLE Db data source. The error from the event viewer is as follows:
Faulting application name: devenv.exe, version: 14.0.25420.1, time stamp: 0x57685d85 Faulting module name: mso40uiwin32client.dll, version: 16.0.4510.1001, time stamp: 0x58aea30f Exception code: 0xc0000005 Fault offset: 0x001665c1 Faulting process id: 0x1634 Faulting application start time: 0x01d2a4d1d4ef28d1 Faulting application path: C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\devenv.exe Faulting module path: C:\Program Files (x86)\Common Files\Microsoft Shared\Office16\mso40uiwin32client.dll Report Id: c15c623e-10c5-11e7-81d4-782bcbacd899
What I'm trying to do: loading data from the excel file and put in sql database. When I create my package at the first time everything work ok, but when I closed and reopen my project I have VS crashing due to the error I reported from the event viewer.
From the error of the event viewer, I had the idea to uninstall office, install only ACE and try again to reopen and work in my project. The project worked again.
My understanding now, is that we cannot have office installed when we want to work with excel as OLE DB Source. Is this true? Can any one help me to overcome this error? I want to have Excel and be able to work in my SSIS project in the same machine
Thank you
After a lot of install/uninstall SSDT2012. We found that we are able to overcome the conflict issue when installing the SSDT2012 from this location:
https://msdn.microsoft.com/en-us/jj650015
I cannot explain why this version can resolve the issue, but what I understand that with this newer version of SSDT2012 we have several enhancement like creating database project in 2012, using sql server 2014 without any trouble, ...