2

Is there any other way rather than "Excel connection manager" to connect Excel as Source in SSIS.

I am asking this question because I have an issue with connecting Excel with "Excel Connection Manager" because in my system Excel 32 bit is installed and the Visual Studio version is 64 bit.

I tried connecting it with ODBC but wasn't successful.

Hadi
  • 36,233
  • 13
  • 65
  • 124
Shahab Haidar
  • 625
  • 3
  • 11
  • 25
  • Is the issue solved? – Yahfoufi Jul 23 '19 at 11:50
  • No. I didn't find any useful answer to this. – Shahab Haidar Jul 23 '19 at 11:52
  • Have you tried the suggestions below? Why didn't replied to the answers so you will get more help – Yahfoufi Jul 23 '19 at 11:53
  • these are not related to my qestion. – Shahab Haidar Jul 23 '19 at 12:14
  • I am asking for any ther ways to connect excel in ssis rather than Excel Connection Manager. Like OleDB or Ado.net Connection? – Shahab Haidar Jul 23 '19 at 12:15
  • Excel Connection Manager relies on OLEDB, the answers below are targeting what you mentioned `I have an issue with connecting Excel with "Excel Connection Manager" because in my system Excel 32 bit is installed and the Visual Studio version is 64 bit`. If running visual studio package in 32-bit didn't worked then installing AccessDatabaseEngine will surely works – Yahfoufi Jul 23 '19 at 12:47
  • Just try the suggestions and give a feedback, they must solve the main issue you are facing – Yahfoufi Aug 01 '19 at 10:12

2 Answers2

0

There is not Visual Studio 64-bit version, I think you should change the Run64BitRuntime Property to False:

Yahfoufi
  • 2,220
  • 1
  • 22
  • 41
0

Install both AccessDatabaseEngine 32bit and 64bit

If you need to install AccessDataBaseEngine x64 alongside with 32-bit installation, you need to run the installation in passive mode:

Passive mode installation steps

  1. Open the Command Prompt by typing cmd in the Windows search box under the Start menu and selecting cmd.exe
  2. Type the file path and file name of the 64-bit Access Database Engine 2010 install file, followed by a space and /passive (this runs the installation without showing any error messages).
  3. Open the Registry Editor by typing regedit in the Windows search box under the Start menu and selecting regedit.exe

  4. Delete or rename the mso.dll registry value in the following registry key: 

    "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths"

More details and screenshots are found in the link below

Reference

Hadi
  • 36,233
  • 13
  • 65
  • 124