sql server 2012中的SSIS包错误

How to resole this error?

如何解决此错误？

Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 10:06:01 AM Error: 2016-08-30 10:06:02.76 Code: 0xC0209303 Source: Package Connection manager "Excel Connection Manager" Description: 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. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2016-08-30 10:06:02.76 Code: 0xC020801C Source: Data Flow Task Excel Source [2] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2016-08-30 10:06:02.76 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: Excel Source failed validation and returned error code 0xC020801C. End Error Error: 2016-08-30 10:06:02.76 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2016-08-30 10:06:02.77 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:06:01 AM Finished: 10:06:02 AM Elapsed: 1.704 seconds. The package execution failed. The step failed.

以用户身份执行：NT Service \ SQLSERVERAGENT。 Microsoft（R）SQL Server执行包实用程序版本11.0.2100.60（适用于64位版权所有（C）Microsoft Corporation）。版权所有。开始时间：上午10:06:01错误：2016-08-30 10：06：02.76代码：0xC0209303源：包连接管理器“Excel连接管理器”描述：请求的OLE DB提供程序Microsoft.Jet.OLEDB.4.0未注册。如果未安装64位驱动程序，请以32位模式运行程序包。错误代码：0x00000000。 OLE DB记录可用。来源：“Microsoft OLE DB服务组件”Hresult：0x80040154描述：“类未注册”。结束错误错误：2016-08-30 10：06：02.76代码：0xC020801C源：数据流任务Excel源[2]描述：SSIS错误代码DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER。 AcquireConnection方法调用连接管理器“Excel连接管理器”失败，错误代码为0xC0209303。在此之前可能会发布错误消息，其中包含有关AcquireConnection方法调用失败原因的更多信息。结束错误错误：2016-08-30 10：06：02.76代码：0xC0047017源：数据流任务SSIS.Pipeline描述：Excel源验证失败并返回错误代码0xC020801C。结束错误错误：2016-08-30 10：06：02.76代码：0xC004700C源：数据流任务SSIS.Pipeline描述：一个或多个组件验证失败。结束错误错误：2016-08-30 10：06：02.77代码：0xC0024107源：数据流任务描述：任务验证期间出错。结束错误DTExec：包执行返回DTSER_FAILURE（1）。开始时间：上午10:06:01完成时间：上午10:06:02经过：1.704秒。包执行失败。步骤失败了。

2 个解决方案

#1

Here 64bit driver is not installed, either install

这里没有安装64位驱动程序，要么安装

https://www.microsoft.com/en-us/download/details.aspx?id=23734

https://www.microsoft.com/en-us/download/details.aspx?id=13255

or run it on 32 bit in the debug/run settings

或者在调试/运行设置中以32位运行它

#2

Your trying to us a 64 bit driver when one is not present. You can install the 64 bit driver or assuming you already have the 32 bit driver installed force it to use a 32 bit runtime. Below is a screenshot of an sql agent job where this setting can be found.

当一个不存在时，你试图给我们一个64位驱动程序。您可以安装64位驱动程序，或者假设您已经安装了32位驱动程序，强制它使用32位运行时。下面是可以找到此设置的sql代理作业的屏幕截图。

#1