sql-server - 包验证错误

Question

我正在尝试使用 foreach 循环容器将几个 excel 文件导入到表中，我指定了要使用的文件夹和文件(*.xls)，之后我创建了一个路径变量，然后我转到 Excel 源连接，并在“表达式”属性中选择了变量。我创建了 foreach 容器，但是 Excel 源的 connectionString 仅显示 Provider=Microsoft.Jet.OLEDB.4.0;，因此这意味着它没有采用变量值。我能做什么来解决这个问题？

注意:我使用的是 SQL Server 2012

其他信息:

Error at Data Flow Task [Excel Source [20]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Error at Data Flow Task [SSIS.Pipeline]: Excel Source failed validation and returned error code 0xC020801C.

Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

Error at Package [Connection manager "Excel Connection Manager"]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.

(Microsoft.DataTransformationServices.VsIntegration)

Answer 1

检查下面的链接，我的回答主要集中在 RUN64BITS TO FALSE 而不是 TRUE。

Execel Source ERROR