Visual Studios 2015 SSIS Crashing on Microsoft.ACE.OLEDB.12.0 Connection to Excel file

0

Thank you in advance for any help!

Working on an SSIS package in Microsoft Visual Studios 2015 which has a connection to an excel doc. I believe I have Visual Studios and SSDT properly installed. Running Windows 10 (64 bit machine); Office 365; 64 bit Excel driver V14.00.7180.5000; 32 bit Excel driver V16.00.4513.1000. I originally just had 32 bit, but added the 64 bit troubleshooting.

In SSIS currently using below connection string:

Data Source=\someFolder\someSubFolder\fileName-2019-07-30-10-40_InProgress.xlsx; Provider=Microsoft.ACE.OLEDB.12.0; Extended Properties=excel 12.0;

When I attempt to test the connection SSIS simply crashes. Looking at the Windows Event View application log the relevant message seems to be:

Faulting application name: devenv.exe, version: 14.0.25420.1, time stamp: 0x57685d85 Faulting module name: mso40uiwin32client.dll, version: 16.0.4519.1000, time stamp: 0x58bed810 Exception code: 0xc0000005 Fault offset: 0x00166226 Faulting process id: 0x47b8 Faulting application start time: 0x01d547b4dff33f93 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 ...

Searching the web for a solution I found reference to that .dll file giving some trouble in the past and accepted solutions I found were to repair Microsoft office (tried that) and to run sfc /scannow on the command prompt (Result: no integrity violations).

Also found mention of running a Process Monitor for any .dll files Visual Studio may be attempting to access which may be missing and found none. The only thing I found from the Process Monitor which may be interesting is the RegOpenKey calls are going to my Current User which does not seem to be where the Microsoft.ACE.OLEDB.12.0 Reg Keys are when I look through the registry. I have not tried moving/copying those reg keys as i'm really not sure i'm right.

Please let me know if anything is unclear, thank you!

visual-studio-2015
ssis
asked on Super User Jul 31, 2019 by N.J. • edited Aug 1, 2019 by N.J.

1 Answer

0

Turns out I had the 64 bit Microsoft.ACE.OLEDB.12.0 driver installed and I needed the 32 bit version. Yay SSIS!

answered on Super User Aug 1, 2019 by N.J.

User contributions licensed under CC BY-SA 3.0