SSIS 包失败并显示错误“如果未安装 64 位驱动程序，请在 32 位模式下运行"
尝试从 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 Redistributable 和
将 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
相关文章