SSIS包失败，并显示错误“如果未安装64位驱动程序，请以32位模式运行”。 [英] SSIS package fails with error "If 64-bit driver not installed, run in 32-bit mode"
问题描述
尝试从SSMS中的Integration Services目录运行程序包时收到以下错误。我将 64BitRuntime 选项更改为 FALSE ，但是它仍然不起作用。下面的错误后面是一个错误，提示无法与我的 Excel连接管理器建立连接。
I am receiving the following error when trying to run the package from the Integration Services catalog in SSMS. I changed the 64BitRuntime option to FALSE but it still does not work. The error below is followed by an error that a connection cannot be made to my Excel connection manager. Any suggestions?
包装错误：所请求的OLE DB提供程序Microsoft.Jet.OLEDB 4.0
未注册。如果未安装64位驱动程序，请以32位模式运行
软件包。错误代码：0x00000000
Package Error: The requested OLE DB provider Microsoft.Jet.OLEDB 4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000
推荐答案
您必须安装 Microsoft Access Database Engine 2010可再发行组件和
将 64BitRuntime 选项设置为 FALSE
You have to install Microsoft Access Database Engine 2010 Redistributable and
set 64BitRuntime option to FALSE
您可以从以下链接获取它：
you can get it from the following link:
- https://www.microsoft.com/en-us/download/details.aspx?id=13255
更多信息和详细信息可以在以下链接中找到：
More info and details can be found in the following links:
- http://sqlblog.com/blogs/john_paul_cook/archive/2010/03/24/running-32-bit-ssis-in-a-64-bit-environment.aspx
- http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html?m=1
- https://msdn.microsoft.com/en-us/ library / ms162810.aspx
- http://sqlblog.com/blogs/john_paul_cook/archive/2010/03/24/running-32-bit-ssis-in-a-64-bit-environment.aspx
- http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html?m=1
- https://msdn.microsoft.com/en-us/library/ms162810.aspx
这篇关于SSIS包失败，并显示错误“如果未安装64位驱动程序，请以32位模式运行”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
