无法通过SSIS连接到Excel [英] Unable to Connect to Excel via SSIS

问题描述

SSIS无法识别Excel文件.

Excel file is not being recognized by SSIS.

错误:

无法从连接管理器"Excel连接管理器"中检索表信息
使用连接管理器"Excel连接管理器"无法连接到源

Could not retrieve table information from connection manager "Excel Connection Manager
Failed to connect to the source using the connection manager 'Excel Connection Manager'

我尝试安装32位可再发行组件来解决此错误，但是当我使用SQL存储过程在外部运行此组件时，它却失败了，如果我安装了64位可再发行组件，但这也可以解决，但是在SSIS中却失败了，

I have tried installing 32-bit of redistributable which resolved this error but when I run this outside using SQL stored procedure it is failing, which is in turn resolved if i install 64 of redistributable but this is failing in SSIS,

因此，我需要32位才能在SP中运行，而需要64位才能在SSIS中运行，但是我不能同时安装两者.这个问题有解决方案吗?

Hence, I need 32-bit to run in SP, and 64-bit to run in SSIS but I cannot install both at the same time. Is there any solution to this issue.

推荐答案

有2种解决方案:

(1)在SSIS中以32位运行程序包

尝试以32位模式运行程序包:

Try running the package in 32-bit mode:

GoTo Project properties >> Debugging >> Run64BitRuntime  = False

(2)同时安装32位和64位AccessDatabaseEngine

假设您用可再分发"的意思指Access数据库引擎

如果需要与32位安装一起安装AccessDataBaseEngine x64，则需要以被动模式运行安装:

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

被动模式安装步骤

1. 通过在开始"菜单下的Windows搜索框中键入cmd并选择cmd.exe来打开命令提示符
2. 键入64位Access Database Engine 2010安装文件的文件路径和文件名，后跟一个空格和/passive(这将运行安装而不显示任何错误消息).
3. 通过在开始"菜单下的Windows搜索框中键入regedit并选择regedit.exe
，打开注册表编辑器.

4. 在以下注册表项中删除或重命名mso.dll注册表值:

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" 

更多详细信息和屏幕截图，请参见下面的链接

参考

• 查看全文